# Need to use "Select All" in a calculation from the control

**URL:** <https://community.amazonquick.com/t/need-to-use-select-all-in-a-calculation-from-the-control/5155>\
**Category:** Q&A\
**Tags:** analysis, calculations, quick-sight\
**Created:** [August 3, 2022, 4:50pm UTC](https://community.amazonquick.com/t/need-to-use-select-all-in-a-calculation-from-the-control/5155 "2022-08-03T16:50:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shubham\_Gupta](https://avatars.discourse-cdn.com/v4/letter/s/b38774/32.png) [@Shubham\_Gupta](https://community.amazonquick.com/u/Shubham_Gupta)\
**Post date:** [August 3, 2022, 4:50pm UTC](https://community.amazonquick.com/t/need-to-use-select-all-in-a-calculation-from-the-control/5155/1 "2022-08-03T16:50:45Z")

</div>

Hi All,

I have a control which has the Select All option and is connected to a parameter. Also I have 2 calculated fields.

My requirement is that when user selects the “Select All” option, display 1st calc field else display 2nd field.

Has anyone come across this requirement?  
Any help is highly appreciated.

Thanks,  
Shubham Gupta

---

<div class="post-metadata">

**Author:** ![DeepakS](https://avatars.discourse-cdn.com/v4/letter/d/b2d939/32.png) [@DeepakS](https://community.amazonquick.com/u/DeepakS)\
**Post date:** [August 5, 2022, 10:07pm UTC](https://community.amazonquick.com/t/need-to-use-select-all-in-a-calculation-from-the-control/5155/2 "2022-08-05T22:07:25Z")

</div>

Hi Shubham,

Please confirm if parameter you are using is defined as single value or multi-value parameter. Multi-value parameters are not usable in calculated fields and single value parameter must have a default value assigned to be used in calculated fields.

A sample eflse expression using parameter is: ifelse(${Segment}='Total,{MoM Sales},{MoM %})

May be you can explain more about what is your use case scenario and there is different way to achieve that.

Thanks  
Deepak

---

<div class="post-metadata">

**Author:** ![WLS-P](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-p/32/36109_2.png) [@WLS-P](https://community.amazonquick.com/u/WLS-P)\
**Post date:** [October 14, 2022, 4:44pm UTC](https://community.amazonquick.com/t/need-to-use-select-all-in-a-calculation-from-the-control/5155/3 "2022-10-14T16:44:45Z")

</div>

Hi, @Shubham_Gupta. Did @DeepakS’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community Q&A Forum!