topic Sum Lines in Line Chart in QlikView

Sum Lines in Line Chart

Tue, 15 Sep 2009 22:34:04 GMT

Hi there,

I manage to add a line to a line chart. This line must be the sum of the previous line. I wonder if there is an option on chart to do so because i can't find it. The line must work for the drill down dimension has well.

Find enclosed an example.

thanks for your help.

Sum Lines in Line Chart

Tue, 15 Sep 2009 22:42:08 GMT

not sure if I understood correctly, but is adding a new expression referring to column(1) and then setting full accumulation to it what you're looking for?

Sum Lines in Line Chart

Wed, 16 Sep 2009 14:58:41 GMT

I've already tried but it doesn't work.

What i mean is that for each view (drill down), i want to diplay the sum of the curves. As of if we have supressed the second dimension...

But i want to see all on the same graph.

Sum Lines in Line Chart

prieper — Wed, 16 Sep 2009 21:05:06 GMT

Cannot think of a way to handle this in one chart (also logically it does not make much sense), but it should be workable to overlay a second chart with same formatting as the first one.

HTH
Peter

Sum Lines in Line Chart

Wed, 16 Sep 2009 23:52:19 GMT

What you can do is use the property aplilar, change to bar graph and put numbers on data points.

Sum Lines in Line Chart

Thu, 17 Sep 2009 00:19:50 GMT

Is this what you are looking for?

Sum Lines in Line Chart

Thu, 17 Sep 2009 17:40:47 GMT

Not teally.

I'm just loking to add a line like the other but equals to the sum of the others.

May be using the reference line and set analisys but i didn't succed.