Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum Lines in Line Chart

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.

6 Replies
Not applicable
Author

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?

Not applicable
Author

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.

prieper
Master II
Master II

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

Not applicable
Author

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

Is this what you are looking for?

Not applicable
Author

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.