Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datashaw
Contributor III
Contributor III

Show last 3 months data using Calculated Dimension in Qlik Sense

Dear Experts,

I have a basic requirement to show last 3 months of the data (ie., May, June, July -2019)
So I've used the caluculated dimention in my Straight table which is


=If((MonthName(PDATE)) >= AddMonths(Max(TOTAL (MonthName(PDATE))), -3), (MonthName(PDATE)))

 

the resulting table gives me total 4 months including current month August Data as well. All I'm interested to see only last 3 months excluding current month

can you please correct/amend me the above calculated dimension

 

In my data model i have only a Date field (PDATE),do not have Month field in Master Calendar

appreciate your help on this 

Labels (3)
0 Replies