topic Combo chart in QlikView

Combo chart

Thu, 20 Aug 2009 14:32:27 GMT

In a combo chart .I need to build a stacked chart and need the lines to depict trend through line expression .

when i try to add expression first expression is for bar nad other expression are represented in lin e. hence the bar is not coming as atcked . I am using personal edition of qlikview

Combo chart

johnw — Fri, 21 Aug 2009 01:33:23 GMT

On the Expressions tab, you have Display Options for each expression. Bar and Line are options. Set them as desired. Stacked on the Style tab should then work fine for what you've defined as bars.

Combo chart

Fri, 21 Aug 2009 18:36:13 GMT

Thankyou John.. 🙂

I am facing another issue .. i need to set the line in the combo chart showing the median of stacked chart ..

for eg : we have different department and no of students for consecutive 3 yr as the stacked value in the bars. here i want the line to depict the average or the median value for each yr ..

Combo chart

johnw — Sat, 22 Aug 2009 02:18:49 GMT

Hmmm, it looks like you can EITHER stack the bars OR have a line, but not have both. That's annoying. I could SWEAR I've done this before, though, and without layering two charts. Yes, I'm looking at an example right now. What am I doing differently?

Ah! I made separate expressions for each bar in the stack. So here's one approach that appears to work. I'm not sure if I have this exactly how you want it, but hopefully it's close enough.

Might as well include the layering approach as well, since neither is strictly superior in all cases.

Combo chart

Thu, 01 Oct 2009 14:05:05 GMT

John, I was looking for this. You totally made my day!

Thanks!