topic Re: Calculation Condition Limitation in QlikView

Calculation Condition Limitation

Anonymous — Mon, 04 Aug 2014 21:47:50 GMT

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

Re: Calculation Condition Limitation

MK_QSL — Mon, 04 Aug 2014 22:11:27 GMT

may be below link useful for you...

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table

Re: Calculation Condition Limitation

Anonymous — Mon, 04 Aug 2014 22:22:47 GMT

Thank you Manish

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

Re: Calculation Condition Limitation

Tue, 05 Aug 2014 18:47:05 GMT

Hi Please use the below:

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