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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get Month-on-Month Growth in Bar Graph

Hi Team,

I ve below data in xl

MonthRev
apr5
apr4
may6
may7


After loading, at bar graph level I am doing sum(Rev) and I am getting below output MoM...

MonthRev
apr9
may13


I want to show Month-on-Month Growth also in the same bar graph (as a symbol)

eg. For the month of May, my growth will be (13-9)/9

Pls suggest how to achieve this!!

Like we have "Full Accumulation" property to get total values, do we have any separate property to get the difference values also..or is there any other approach?

1 Reply
Not applicable
Author

Hi,

If i understood your question properly, Below expression will help you to achieve the desire result.


(Sum (val) - above(Sum (val)))
/
above(Sum (val))


-Peterson