Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dimension limits on months.

Hi All,

I am new to qliksense.I need a help to show only 6 months data from today. I am using  MonthYr (MMM-YY) as a dimension.

i want to limit on 6 months Would really appreciate your help. Thanks.

4 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

You can select the first six months in the MonthYr filter.

1.jpg

You can also use set analysis expressions . An example in the attached file (Table2).


Regards,

Andrey

Anonymous
Not applicable
Author

I need dynamic, anyway i have done using the below.

=if([Start Date Actual] <= today()+150 and [Start Date Actual] > today(), date([Start Date Actual],'MMM-YY'))

ahaahaaha
Partner - Master
Partner - Master

May be like at attached file for days

ahaahaaha
Partner - Master
Partner - Master

Or like this (look attached file)

Sum({<MonthYr={"=Num(Month((Date#(MonthYr, 'MMM-YY'))))>=Num(Month(Today()))"}

*{"=Num(Month((Date#(MonthYr, 'MMM-YY'))))<Num(Month(Today())+6)"}>}Value)