show only one value in bar chart

[Anonymous]

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

[Oleg_Troyansky · Accepted solution]

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!

[swuehl]

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

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