Discussion board where members can get started with Qlik Sense.
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.
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).
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)