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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
DGAL1
Contributor III
Contributor III

Month to Month % change

I have a dates that show sales for the different month's column and I want to present a  bar graph that represents a % change one month to another month. Kindly help on the formula i can do this

Labels (1)
3 Replies
jonashertz
Contributor III
Contributor III

If you do it in chart the above() function would be a good way to do it.

( sum(Amount)-above(sum(Amount)) ) / above(sum(Amount))

DGAL1
Contributor III
Contributor III
Author

Thanks @jonashertz , the above has helped me

 

Anil_Babu_Samineni
MVP
MVP

@DGAL1 Please accept as solution for correct answer to clean community threads better. 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful