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

    Filling missing values with previous data (File attached)

      Hello,

       

      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.