topic Re: how to create a stack bar chart + with value on each of the stack. in QlikView

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

jim_chan — Tue, 23 Aug 2016 09:36:22 GMT

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)

Rgds,

Jim

Anil_Babu_Samineni — Tue, 23 Aug 2016 09:40:07 GMT

How your dimension? Meantime, can I know expected output

jim_chan — Tue, 23 Aug 2016 09:42:47 GMT

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

adamdavi3s — Tue, 23 Aug 2016 09:43:46 GMT

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 — Tue, 23 Aug 2016 09:54:33 GMT

Hello Adam,

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

Rgds

Jim

adamdavi3s — Tue, 23 Aug 2016 09:57:48 GMT

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:

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

jim_chan — Tue, 23 Aug 2016 10:09:04 GMT

thank you