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: 
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

@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