Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vince_CH
Creator III
Creator III

Multiple lines accumulative in line chart

Hello Community,

I have a line chart with multiple measures as below illustrated, which all starts since 0 in Y axis direction, with some are overlapped not good to see. Is it possible to stack one measure on another in line, with the two lines gap being the new measure result,  and accumulative so on in Y axis diection with further measures? 

Having tried to use above() and rangesum(), but not very understanding their concept on this case,  kindly please advise. thanks

11.jpg

1 Solution

Accepted Solutions
4 Replies
OmarBenSalem

if u want to accumulate ur expression:

u change it from:

sum(Measure)

to

rangesum(above(

sum(Measure)

,0,rowno()))

Now, if u have 2 dimensions as in ur case (dim1 and dim2)

u have to Aggregate by dim2 then dim1:

Aggr(

rangesum(above(

sum(Measure)

,0,rowno()))

,dim2,dim1)

Vince_CH
Creator III
Creator III
Author

@OmarBenSalem
Thanks for reply. But I have one dimension as Fiscalyear, with multiple measures, e.g. measure1, measure2, measure3, measure4, currently in chart, they overlapped hard to see clearly if data were similar. Is it possible to overlay one measure line on the top of another visiually? similarly like stacked bar charts but in lines?
OmarBenSalem

Under presentation:

Capture.PNG

Vince_CH
Creator III
Creator III
Author

thanks, I noticed it now 🙂

But still confusing about in what scenario to use above() or rangesum() etc.