4 Replies Latest reply: Feb 25, 2016 4:35 AM by Sunny Talwar RSS

    Accumulation in expression

      Hi All,

      I am new to qlikview and created a chart for actual and budget.

      I have tried to sum up and display accumulated value using full accumulation and it displaying as per expected, but I don't want to show accumulated value, if there is no data value available. As per screen shot, data is only available for 4th and 5th, so it should accumulate till 5th and from 6th it should be blank.

      qlikview erroe.GIF

      Can anyone please help me in providing expression to achieve this.

      Please explain in detail, as i am very new to qlikview.

       

      Regards

      Ankathi