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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
katetsan
Creator
Creator

Difference between latest two months

Hi Expert,

I have a pivot table and had created a new column called 'MoM' by using pick function.

Now, I have another problem to calculate the difference between latest two months.

Is there any suggestion could help me out?

Please refer the 'MoM' Column in attached qvw filw.

Thanks a lot.

1 Solution

Accepted Solutions
balar025
Creator III
Creator III

Hello,

Please find updated application. I have updated your formula for Operation income and sub items.

View solution in original post

2 Replies
tresesco
MVP
MVP

PFA.

Made correction in variable definition  vLastMonth and in expression it was LastMonth instead of vLastMonth

balar025
Creator III
Creator III

Hello,

Please find updated application. I have updated your formula for Operation income and sub items.