Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

somspalanisamy
New Contributor III

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.

Tags (1)
4 Replies
ahaahaaha
Honored Contributor

Re: Dimension limits on months.

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

somspalanisamy
New Contributor III

Re: Dimension limits on months.

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
Honored Contributor

Re: Dimension limits on months.

May be like at attached file for days

ahaahaaha
Honored Contributor

Re: Dimension limits on months.

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)

Community Browser