Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
maybe this:
= rangesum(above(sum(Value), 0, RowNo() ) )
May be this
If(Sum(Value) > 0, RangeSum(Above(Sum(Value), 0, NumericCount(Value))))
Dual(If(MonthYear=Max(MonthYear), Country, ''),Sum(value))
**Note :
you should change the fields country ,value according to your need.