Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
apoorvasd
Contributor II

Show totals in Bar graph

Hello everyone,

There are two expressions and one dimension in my bar graph. Is it possible to show a single bar at the end which calculates and displays the TOTAL for one expression and doesn't display for the other expression?

I would like to see something like in attached picture (Totals).

If not, is it at least possible to show TOTAL for just red bar and neglect the one that has constant values through out (as in picture, Totals2)?

Thank you.

4 Replies
MVP
MVP

Re: Show totals in Bar graph

Dimension Limit tab-> enable 'Show Total'

apoorvasd
Contributor II

Re: Show totals in Bar graph

Hi Tresesco,

I have tried that, if I enable "Show Total" option, then it would calculate total for both expressions and then display total for both blue and red bars which I don't want. I would just like to see the sum calculated for the red bar expression and not for the blue bar. For blue bar, the value is constant and I would like to keep that same value in totals as well. Is that possible?

Thank you.

MVP
MVP

Re: Show totals in Bar graph

One way could be playing with background/text color like:

Capture.PNG

apoorvasd
Contributor II

Re: Show totals in Bar graph

Hello,

Yes, this is a possible solution. But the only problem is, as the scale increases, length of other bars are reduced. I will check if I can change this. Will wait for few more replies and see. Anyways thank you for your suggestion and quick response.

Community Browser