topic Stacked bar chart - Display % and count in QlikView

Stacked bar chart - Display % and count

Mon, 01 Mar 2010 04:36:35 GMT

Hello,

Does anyone know how to display percentage and total count in stacked bar chart?

I created a stacked bar chart in percentage, but i'd like to show total number of count at the data point or above every stacked. Is it possible to do so?

Stacked bar chart - Display % and count

gajapathy74 — Mon, 01 Mar 2010 08:23:36 GMT

Hi,

To my knowledge we can't display the % and count together using single expression. You need to add additional expression to show either % or count. In the additional expression, disable the selection of "Bar" (check box) and enable "Text as Pop-up" (check box) under Display options. Please refer attached image file.

Hope this would help you.

Regards,

Stacked bar chart - Display % and count

Mon, 01 Mar 2010 08:58:17 GMT

Hi RG,

Thanks! it works!

Another question, when i move my mouse on the stacked, i'll see the pop-up, i can see my figure showing in the following format, how do i add the label for the count? i did fill the field LABEL, but, it's still not showing. Thanks if you could provide some tips.

Total = 20%
11

Stacked bar chart - Display % and count

gajapathy74 — Mon, 01 Mar 2010 11:38:21 GMT

Hi,

Please append your label before your expression. Assuming your label is "Count" and your expression is "Count(Field)".

='Count: ' & Count(Field)

Regards,

Stacked bar chart - Display % and count

Tue, 31 Jan 2012 10:24:20 GMT

Hi, this is really helpful but when I do this the value is around 15 for the bottom stack of my chart but the chart axis runs from 0 to 1 so this value is showing as a pop up for the whole chart. Thus when I do the same for my next stack the pop up will not show as the value is off the chart.

Is there a way to make this work?

Thanks

Dylan

Re: Stacked bar chart - Display % and count

Anonymous — Tue, 19 Mar 2013 20:01:37 GMT

Can someone specify how we can do the same if we have multiple expressions?

i have stacked bar chart , each segment of the bar should show its respective count and percentage ..is this possible?

When i implemented the above soloution , i get % for the specific segment of the bar and counts of all segments in the bar displayed ..when hovered over..

Thanks

Re: Stacked bar chart - Display % and count In QlikSense

Mohith15102020 — Tue, 10 Dec 2019 00:57:58 GMT

Hello Gajapathi,

If i want to achieve the same in Qlik Sense( June 2018 ). How can i show both Percentage & Count in Stacked Bar Chart.

Can you or any of our Qlik folks suggest me the directions. Thanking you all...

Any qvf file or example will help too.