Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
ziabobaz
Contributor III

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 ; 

1 Solution

Accepted Solutions
robin_hausdoerfer
Valued Contributor III

Re: Accumulation of Measure in script


TempTable_Data2


will be concatenated implicitly to TempTable_Data because they share 100% identical field names...

4 Replies
robin_hausdoerfer
Valued Contributor III

Re: Accumulation of Measure in script

try placing

noconcatenate

between the loads.

robin_hausdoerfer
Valued Contributor III

Re: Accumulation of Measure in script


TempTable_Data2


will be concatenated implicitly to TempTable_Data because they share 100% identical field names...

ziabobaz
Contributor III

Re: Accumulation of Measure in script

I should have asked at start

Spent half of the day playing with the script )

At least I mastered it.

Thank you!

robin_hausdoerfer
Valued Contributor III

Re: Accumulation of Measure in script

meanwhile I write concatenate / noconcatenate explicitly between every load.