topic Re: show only one value in bar chart in QlikView

show only one value in bar chart

Anonymous — Wed, 20 Jan 2016 18:39:42 GMT

Hi all,

I need to plot a bar chart using one value but need to show a diff value (ie.e change in percentage)

plz find the attached.

in the below example I'm showing the both bar chart one with value and other with difference between month

want to show both in one chart

Regards

Sri1

Re: show only one value in bar chart

Oleg_Troyansky — Wed, 20 Jan 2016 18:45:30 GMT

Simply add your secondary expression to the same chart, clear the "Bar" representation and check "Show values on data points". The values will be presented on top of the bars, just as you'd want. See attached.

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!

Re: show only one value in bar chart

swuehl — Wed, 20 Jan 2016 18:49:00 GMT

And to get your percentage change, use this as expression:

=Num(Sum(value)/Above(sum(value))-1,'#.00%','.',',')