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

Sum of all values as third bar in Bar Chart

qlikwiz123 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Mon, 01 Oct 2018 13:48:16 GMT

May be add a total bar from Dimension Limits tab

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

qlikwiz123 — Mon, 01 Oct 2018 13:59:34 GMT

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

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

qlikwiz123 — Mon, 01 Oct 2018 14:02:09 GMT

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

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

sunny_talwar — Mon, 01 Oct 2018 14:11:13 GMT

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

Sum(Measure)/Sum(TOTAL Measure)

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

qlikwiz123 — Mon, 01 Oct 2018 14:21:06 GMT

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

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

sunny_talwar — Mon, 01 Oct 2018 14:23:18 GMT

Super