Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Show last 13 months based on current month

Hi all,

i had a field reportmonth which has value like 2018-01,2018-02.

 

It is in text value .

i want to show use this as as dimension as chart. but in dimension i want to show only last 13 months date.

 

Can any one suggest me what to do ....it seems my logic is not working

 

Kind Regards

 

1 Reply
rahulpawarb
Specialist III
Specialist III

Please use Master Calendar and use below configuration.

//Dimension

reportmonth

//Measure

Sum({<Date={">=$(=MonthStart(AddMonths(Max(Date), -12))) <=$(=Max(Date))"}>}Sales)

 

Hope this will help.

- Rahul