Discussion Board for collaboration related to QlikView App Development.
I have a field which contains 12 months.
I want only 6 months in bar chart and those are 'JAN',FEB','SEP','OCT','NOV','DEC'
Is it possible to achieve this using 'add calculated dimension' option??
If not how to get this?
use calculated dimension
if (match(yourmonthfield,'JAN',FEB','SEP','OCT','NOV','DEC')>0, yourmonthfield)
other way: restrict in Expression using set Analysis (but easier in Dimension)
also depends on whether months are static or dynamic
if dynamic, use variable to store dynamic months
View solution in original post
This months ('JAN',FEB','SEP','OCT','NOV','DEC') are they going to be static not changing regardless of current month users selected?
and then check the check boox supress when value is null for dimension that dimension
hope this helps, if not please add sample document to better understand your issue
Thanks for solution.
How can one achieve this using set analysis?
you need to put the set analysis in each expression!