topic Combo chart with Stacked Bar in QlikView

Combo chart with Stacked Bar

Anonymous — Fri, 29 Sep 2017 09:42:15 GMT

Hi All

I have a stacked bar chart which shows values by customer by week. I want to add a line graph to compare the total value by week for the previous year. If I do a combo chart it won't let me choose stacked as an option for the bar chart, and if I have customer as a dimension the line chart is wrong. Is there a way around this?

Thanks

Re: Combo chart with Stacked Bar

prat1507 — Fri, 29 Sep 2017 09:57:54 GMT

I know this won't sound good, but what you can do is a workaround, just add a copy of the chart you're using and change it to combo chart, add line graph and make the bars invisible and change the transparency of the background to 100%.

This may degrade your performance so use it wisely.

Regards
Pratyush

Re: Combo chart with Stacked Bar

vinieme12 — Fri, 29 Sep 2017 14:21:03 GMT

Just keep one Dimension

and add separate expressions for each stack element

add you expression for the line and change it 's Axes to [right (top) : or different for what you have for the stack bar chart expressions]

that is it!