Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP 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

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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