Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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

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?

1 Solution

Accepted Solutions
Highlighted
Anonymous
Not applicable

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

6 Replies
Highlighted
Partner
Partner

Hi,

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


Highlighted
Creator III
Creator III

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

Highlighted
Anonymous
Not applicable

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

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

Hi Rudolf,

Thanks for solution.

How can one achieve this using set analysis?

Highlighted
Anonymous
Not applicable

you need to put the set analysis in each expression!

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