topic Total sum as a separate bar in QlikView

Total sum as a separate bar

Thu, 13 Jul 2017 09:28:07 GMT

Hi,

I am creating a bar chart and I want to show a separate bar with the total count.

For example:

I have a table as:

Col1	Col2
A	10
B	20
C	30

When I use a bar chart, with Col1 as my dimension and Col2 as my expression, I should get a separate bar showing Total as 60.

I have tried searching for the solution but to no avail. Could you please let me know if this can be done?

Re: Total sum as a separate bar

vishsaggi — Thu, 13 Jul 2017 15:08:02 GMT

IN the bar chart properties dimension limits tab use Show Total check.

Re: Total sum as a separate bar

sunny_talwar — Thu, 13 Jul 2017 15:16:57 GMT

Enalble show total on the dimension limits tab

Re: Total sum as a separate bar

Fri, 14 Jul 2017 07:19:22 GMT

Thanks! That worked.

Re: Total sum as a separate bar

oknotsen — Fri, 14 Jul 2017 11:34:41 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .