Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bellamae
Valued Contributor

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

Re: Calculation Condition Limitation

3 Replies

Re: Calculation Condition Limitation

bellamae
Valued Contributor

Re: Calculation Condition Limitation


Thank you Manish

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

Not applicable

Re: Calculation Condition Limitation

Hi Please use the below:

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

Community Browser