100% stacked bar chart in qlikview with values on the stacked bars

[Anonymous]

Hi All,

I have a requirement to create a stacked bar chart like the one below.(req.png)

I have been able to create the chart like this (Charts1.png).

Is there anyway I can get the Values on the bars as shown in the requirement?

As of now Im getting the percentages on the bars.

Any help will be great because I have just not been able to crack this.

Expressions used till now.

Actuals %---(Sum(TOTAL<[Product Group],[Product Subgroup]>{$<Quarter={'$(vCurrentQuarter)'}>}Value)/1000)/2/

((Sum(TOTAL<[Product Group],[Product Subgroup]>{$<Quarter={'$(vCurrentQuarter)'}>}Forecast)/1000)/2)

[1-Actuals%]--Gap to forecast

Thanks a lot!

[maxgro]

maybe it helps you

[Anonymous]

Thank you Massimo!

[maxgro]

When you think you get the answer, please close this discussion by giving Correct and Helpful answers to the posts which are useful for you.  It helps others in finding answers for similar scenarios. Thanks and good Qlik.

[nikita42]

Hi, I'm currently facing the same issue with stacked bar charts. Can you explain what you've done in your solution?

Thanks!

[jmalenfant]

I'd also like to understand how you've done this. I read that you have to load your data in a specific way (cross tables I think), but is that actually necessary?

[mvaugusto]

This help me!!!

Thank you!

[#8]

I want the same thing. Gap to target filled with red bars, but in a grouped bar chart. So instead of one expression, I have two expressions. And for both expressions the target is 100% and I want the gap to target to be filled in red.