4 Replies Latest reply: May 22, 2018 12:33 PM by Robin Hausdörfer RSS

    Accumulation of Measure in script

    Глеб Аитов

      Hi,

       

      I am following the document Generating Missing Data In QlikView, the Example: Accumulate a number section.

       

      I have Table1:

      There can be multiple transactions with different Amounts within one Date/Co/CashFlow combination.

      DateCompanyAccountCashFlow

       

       

      I need to:

      - aggregate the table

      - add accumulated CashFlow field

       

       

      Below is my script (apart from master calendar and other misc code):

       

      TempTable_Data:

      Load

            Company

          Account

          Date,

          CashFlow

         

      Resident MainTable; //I derive all values from the MainTable, which I will subsequently drop


      //Aggregate table - I want to group all CashFlows
      TempTable_Data2:

      Load

            Company,

          Account,

          Date,

          Sum([CashFlow]) as CashFlow

         

      Resident TempTable_Data

      Group By Company, Account, Date;


      Drop Table TempTable_Data; 


      //As per the instruction from the link below
      NewTable:

      Load

          Company,

          Account,

          Date,

         

              If( Account=Peek(Account),    // if the Account is the same as in the previous row

          RangeSum([CashFlow],Peek([AccCashFlow)),

          RangeSum([CashFlow]))

             

              as AccCashFlow 


      Resident TempTable_Data2  ??? Here I receive error that table TempTable_Data2 not found

      Order By Company, Account, Date; 


      Drop Table TempTable_Data2 ; 

      Drop Table MainTable ;