topic Re: How to add percentage change in line chart in QlikView

How to add percentage change in line chart

Anonymous — Mon, 27 Nov 2017 14:23:29 GMT

Dear community,

i would like to add the year to year change in percentage points to a graph like this (~ 4,3 % for 2016 and ~ 24,8% for 2017).

Is there a simple way to add this piece of information to the graph?

Thanks and Best regards

Re: How to add percentage change in line chart

MarcoWedel — Mon, 27 Nov 2017 20:59:12 GMT

Hi,

you could use the Dual() function to add this information to your expression like this:

Dual(Num(Sum(Value),'#.##0')&Chr(10)&Num(Sum(Value)/Above(Sum(Value))-1,'+0,0%;-0,0%'),Sum(Value))

hope this helps

regards

Marco

Re: How to add percentage change in line chart

Anonymous — Wed, 29 Nov 2017 12:47:13 GMT

Dear Marco,

Thank you very much for your rapid! and outstanding! support.

First, I copy pasted the expression into my file and adjusted it to my dimensions BUT the graph did not change accordingly. Instead the graph still looked like a regular "sum()" graph.

Then I copied the object from your attached qvw file into my sheet and adjusted the expression. It worked! I am still figuring out what I missed but I am very thankful.

Best regards

Re: How to add percentage change in line chart

MarcoWedel — Wed, 29 Nov 2017 19:31:50 GMT

Hi,

you're welcome.

Glad it helped.

Maybe you had some number format applied to your chart expression (needs to be "expression default". see number tab in chart properties).

regards

Marco