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

    Accumulated Line Chart Appearance

    Shashank Sood

      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.