Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Vince_CH
Contributor II

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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Multiple lines accumulative in line chart

Under presentation:

Capture.PNG

4 Replies
Partner
Partner

Re: Multiple lines accumulative in line chart

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
Contributor II

Re: Multiple lines accumulative in line chart

@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?
Partner
Partner

Re: Multiple lines accumulative in line chart

Under presentation:

Capture.PNG

Vince_CH
Contributor II

Re: Multiple lines accumulative in line chart

thanks, I noticed it now 🙂

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