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: 
s2016
Contributor III
Contributor III

Accumulated Line Chart Appearance

Hi,

I am trying to create an accumulated Line chart in QlikSense displaying 5 metrics against MonthYear.

Some of my metrics have values only for a few months and I want to display that line only till the last month the data is available. Attached is a sample chart created in Excel.

I am using the below formula for accumulation but it shows one extra data point as 0 (PFA). Also, another problem with this formula might be if there is a data point after a few missing months, it would not rangesum correctly.  

= rangesum(above(sum(Value), 0, NumericCount(Value)))

Can someone suggest a better way to achieve this.

4 Replies
shanky1907
Creator II
Creator II

Hello Shashank,

Try the below condition in your set analysis:

MonthYear={'>=$(=YearStart(Max(MonthYear)))<=$(=AddYears(Max(MonthYear),0))'}

It will give you accumulated Line chart

agigliotti
Partner - Champion
Partner - Champion

maybe this:

= rangesum(above(sum(Value), 0, RowNo() ) )

sunny_talwar

May be this

If(Sum(Value) > 0, RangeSum(Above(Sum(Value), 0, NumericCount(Value))))

Anonymous
Not applicable

Dual(If(MonthYear=Max(MonthYear), Country, ''),Sum(value))



**Note :


you should change the fields country ,value according to your need.