Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculation Condition Limitation

Morning all

I am trying to use the calculation condition on a chart to ensure that the user selects a filter before information is displayed.  I usually use =if(len([Transaction_Date Month])>0 or len([Transaction_Date Year])>0, 1,0) type equations but this doesn't work when the user selects more than one option in a filter multibox.  I have tried GetCurrentSelections([Transaction_Date Month]) and concat({$}distinct [Transaction_Date Month] but neither of these work either.

If anyone know of a formula i can use that will not switch on till something is selected but will also recognise more than one selection in a field I would much appreciate it.

Bella

1 Solution

Accepted Solutions
3 Replies
Anonymous
Not applicable
Author


Thank you Manish

I use a customizable startight table in my document but didn't think of that calculation condition.

Not applicable
Author

Hi Please use the below:

if(getselectedcount([Transaction_Date Month])>0 or getselectedcount([Transaction_Date Year])>0, 1,0)