Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
srikanthsri1
Valued Contributor

show only one value in bar chart

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

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: show only one value in bar chart

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!

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: show only one value in bar chart

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!

View solution in original post

MVP
MVP

Re: show only one value in bar chart

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

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