2 Replies Latest reply: Oct 22, 2017 1:52 PM by VIJAY VIRA RSS

    Ending Balance Sum by Month

    Richard Hardin

      I am relatively new to Qlik and have the following data set

       

      Header 1Header 2Header 3Header 4Header 5Header 6
      Beginning balancetransaction dateMonthDebit CreditEnding Balance
      1001/10/2017Jan1090
      901/13/2017Jan30120
      1201/26/2017Jan100220

       

      I want to chart the ending balance for Jan and months following but instead of 220 I end up with 430.

       

      Not sure of the right way to sum this.  Any advise is greatly appreciated.

      Thank you