Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

how to create a stack bar chart + with value on each of the stack.

Hi guys,

i want to create a stack bar chart that have "High, Medium. Low' and show value in each of the bar. As per this screenshot,

I have a expression as below, but it didnt work. I have attached my example as well.

count({<gr_impact={'High'}>} gr_impact) +

count({<gr_impact={'Medium'}>} gr_impact)+

count({<gr_impact={'Low'}>} gr_impact)

barchart.jpg

Rgds,

Jim

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

Hi Jim,

My apologies I missed that part of the requirement...

On 'Presentation' tab, enable the ;Values on Data Points' option and that should work for you:

Capture.PNG

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

View solution in original post

6 Replies
Anil_Babu_Samineni

How your dimension? Meantime, can I know expected output

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jim_chan
Specialist
Specialist
Author

in the sample i have attached, i used "risk_no" as my dimension. expected result as the image i have attached.

adamdavi3s
Master
Master

Hi Jim,

I am not clear on what output you expect here...

Each risk appears to only have one gr_impact assigned to it, so having risk as the x axis is never going to give you a stacked chart.

I've amended your example slightly, is this what you wanted?

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

jim_chan
Specialist
Specialist
Author

Hello Adam,

You're right. My mistake. So, how can I display numbers in each of the stack?

Rgds

Jim

adamdavi3s
Master
Master

Hi Jim,

My apologies I missed that part of the requirement...

On 'Presentation' tab, enable the ;Values on Data Points' option and that should work for you:

Capture.PNG

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

jim_chan
Specialist
Specialist
Author

thank you