Dimension limits on months.

[Anonymous]

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.

[ahaahaaha]

Hi,

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

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

Regards,

Andrey

[Anonymous]

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]

May be like at attached file for days

[ahaahaaha]

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)