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

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

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

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 QuickSight Community Q&A Forum!