Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Sum of all values as third bar in Bar Chart

I have a field Category which has A and B as values and I am performing a count on another field that has values linked to these A and B values.

In a bar chart, when I Category as Dimension, I am seeing two bars, each for A and B and values on it. How do I show third bar which is sum of values A and B? For example, if A is 20 and B is 30, I need to show third bar which is sum of A and B, i.e; 50

Tags (3)
1 Solution

Accepted Solutions
Highlighted

Re: Sum of all values as third bar in Bar Chart

May be add a total bar from Dimension Limits tab

View solution in original post

6 Replies
Highlighted

Re: Sum of all values as third bar in Bar Chart

May be add a total bar from Dimension Limits tab

View solution in original post

Highlighted
Creator II
Creator II

Re: Sum of all values as third bar in Bar Chart

How did I miss this small detail that does the job Thanks a lot Sunny Always ready to help

Highlighted
Creator II
Creator II

Re: Sum of all values as third bar in Bar Chart

What if I want the numbers to be shown as Percentage?

Highlighted

Re: Sum of all values as third bar in Bar Chart

You mean like 40%, 60% and 100%? May be like this

Sum(Measure)/Sum(TOTAL Measure)

Highlighted
Creator II
Creator II

Re: Sum of all values as third bar in Bar Chart

Yes Sunny. For some reason, the values are not correct, maybe because Field 'Category' has String Values - A and B? Don't think so. Anyway, I created an empty Expression and Checked ' Relative'. Now I see the percentage. Thank you so much for your quick help Really appreciate it

Highlighted

Re: Sum of all values as third bar in Bar Chart

Super