Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show in a bar chart the quarter by quarter change as a %?

Untitled.png

Hi there,

How could I represent quarter by quarter change as a %, on the line graph on this bar chart? For example, 2014-Q2 (225k) to 2014-Q1 (175k) is 28.6% var % quarter by quarter, but here it shows 9.9% which is the relative % of the overall volume on the graphical representation.

Thanks very  much!

DK

1 Reply
Roop
Specialist
Specialist

aggr(sum(Value)-Above(sum(Value)), Quarter)/sum(Value)

Hope this helps