10 Replies Latest reply: Jun 25, 2013 10:25 AM by test test RSS

    Filling missing values with previous data (File attached)



      This is what I want to do:

      I want to show the total stock in the past months. The stock is calculated using the current stock level with transaction history.


      Problem is, when a month has no transactions, the stock level is 0. When calculating the total stock in that month, the total will be inaccurate.


      Can someone please look at my Qlikview file? I have been struggling with this for the past 2 days.


      Thanks in advance.