4 Replies Latest reply: Nov 6, 2017 8:12 AM by Allu Allu

Accumulated Line Chart Appearance

Shashank Sood Nov 6, 2017 12:04 AM

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.

Expected_Chart.JPG 37.1 K
Current_Chart.JPG 54.1 K

Re: Accumulated Line Chart Appearance

Shashank Vyas Nov 6, 2017 1:58 AM (in response to Shashank Sood)

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
Like Show 0 Likes (0)

Actions
Re: Accumulated Line Chart Appearance

Andrea Gigliotti Nov 6, 2017 3:37 AM (in response to Shashank Sood)

maybe this:
= rangesum(above(sum(Value), 0, RowNo() ) )
Like Show 0 Likes (0)

Actions
Re: Accumulated Line Chart Appearance

Sunny Talwar Nov 6, 2017 7:40 AM (in response to Shashank Sood)

May be this

If(Sum(Value) > 0, RangeSum(Above(Sum(Value), 0, NumericCount(Value))))
Like Show 0 Likes (0)

Actions
Re: Accumulated Line Chart Appearance

Allu Allu Nov 6, 2017 8:12 AM (in response to Shashank Sood)

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

**Note :

you should change the fields country ,value according to your need.
Like Show 0 Likes (0)

Actions

Go to original post