Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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