Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
may be below link useful for you...
http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table
may be below link useful for you...
http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table
Thank you Manish
I use a customizable startight table in my document but didn't think of that calculation condition.
Hi Please use the below:
if(getselectedcount([Transaction_Date Month])>0 or getselectedcount([Transaction_Date Year])>0, 1,0)