Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
amita1621
Contributor III
Contributor III

query to calculate diff between 2 month data

I have attached a file for the  reference i have  created the file with current and prev month data by using pivot in qlikview, now how can i calculate % change from Prior Month.

COuld you please help??

13 Replies
amita1621
Contributor III
Contributor III
Author

Please see the attached QV file. i am getting % for each band , how can i have the total change at the end, same as above excel attcahed

sunny_talwar

Amita, would you be able to share a more representative sample to help you better

amita1621
Contributor III
Contributor III
Author

yes sure thanks

amita1621
Contributor III
Contributor III
Author

Sorry  to bother so many times.

Please check the qlikview file i created and now i need % change at the last based on Month