Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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,
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,
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
Hi,
Please append your label before your expression. Assuming your label is "Count" and your expression is "Count(Field)".
='Count: ' & Count(Field)
Regards,
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
Hi
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
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.