topic Re: How to restrict months using 'Add calculated dimension' option? in QlikView

How to restrict months using 'Add calculated dimension' option?

mallikarjun_h — Thu, 02 Apr 2015 09:46:54 GMT

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?

Gabriel — Thu, 02 Apr 2015 10:10:02 GMT

Hi,

This months ('JAN',FEB','SEP','OCT','NOV','DEC') are they going to be static not changing regardless of current month users selected?

Anonymous — Thu, 02 Apr 2015 10:16:04 GMT

if(match(monthnamefield,'JAN',FEB','SEP','OCT','NOV','DEC') ,monthnamefield)

and then check the check boox supress when value is null for dimension that dimension

Anonymous — Thu, 02 Apr 2015 10:16:28 GMT

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

Anonymous — Thu, 02 Apr 2015 10:17:32 GMT

hope this helps, if not please add sample document to better understand your issue

mallikarjun_h — Tue, 07 Apr 2015 12:55:34 GMT

Hi Rudolf,

Thanks for solution.

How can one achieve this using set analysis?

Anonymous — Tue, 07 Apr 2015 13:05:40 GMT

you need to put the set analysis in each expression!

e.g. sum({<month={'JAN','FEB','SEP','OCT','NOV','DEC'}>}yourvaluefield