Stacked chart with total

[Anonymous]

Hi,

there is a problem with a kombi-chart. Three bars should be stacked in percent and Total is one line. First stacked bar have right values in chart. If I add line chart, bars are not stacked? In second chart bars are stacked but I have wrong values.

Regards Stefan

[fvelascog72]

Hi,

You cannot use stacked bars in a combochart if you have more than one expression.

If you search in the community there are a lot of cases like yours.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. Is that more like what you're looking for?

[Anonymous]

Hi, that's exactly what i'm looking for.

[Anonymous]

One question again? How can I fixed y-axis to 100%

[Gysbert_Wassenaar]

On the Axes tab set the Static Max setting to 1 for the expression axes

[Anonymous]

Thank so lot. Is it possible to have 100% in every stacked bar?

[Gysbert_Wassenaar]

Yes, but then the percentages will change. Instead of dividing by Count(total QP_neu) divide by Count(total <dq_mon_FY> QP_neu)