Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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'))
May be like at attached file for days
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)