Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
amilafdo
Creator
Creator

Last Month Data

Hi,

Can any one let me know, how to take the last month data in Pivot table?

Thanks

Amila

2 Replies
ecolomer
Master II
Master II

You can use Min(Month), but this depend your data.

¿Can you upload example?

Not applicable

It depends upon how you are taking your Months. Generally we have a MonthSequence associated and then use that column to go to previous month. Search for Previous month in community and you will get many related articles.