Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

padma588
New Contributor

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

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!

7 Replies
MVP
MVP

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

maybe it helps you

padma588
New Contributor

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

Thank you Massimo!

MVP
MVP

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

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
New Contributor

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

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

Thanks!

jmalenfant
New Contributor II

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

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
Contributor

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

This help me!!!

Thank you!

Not applicable

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

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.

Community Browser