1 Reply Latest reply: May 8, 2017 7:50 AM by Sunny Talwar RSS

    how to use one field value in second column that is in another column

    Kaleem Ullah
      Header 1Header 2Header 3Header 4
      BANK_IDDATEOPENING BALANCECLOSING BALANCE
      11/8/20167M8M
      12/8/2016---

      I have this table i have only one Opening balance for 1/8/2016 i want to populate the next opening balance which should be previous closing balance ie opening balance for 2/8/2016 should be 8M which is the closing balance of the previous date..i am new to qlik please help me.