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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
imtiaz_ullah
Creator
Creator

Calculate measure vs Previous Month

Hi all,

I have a calculated measure (OpenRate%) in QS and in my result set I also have MonthName being returned.

I am trying to calculate the difference in the measure vs previous month.

Are there any inbuilt functions that I can use to achieve this or is this more complex than it sounds?

Thanks

Immy

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Maybe [OpenRate%] - above([OpenRate%])


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Maybe [OpenRate%] - above([OpenRate%])


talk is cheap, supply exceeds demand
imtiaz_ullah
Creator
Creator
Author

Wow! That was easy... works a treat (I think, just sanity checking the values)

Thanks