
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Stacked bar chart - Display % and count
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?
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please append your label before your expression. Assuming your label is "Count" and your expression is "Count(Field)".
='Count: ' & Count(Field)
Regards,

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
