Discussion board where members can get started with Qlik Sense.
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.
I need to:
- aggregate the table
- add accumulated CashFlow field
Below is my script (apart from master calendar and other misc code):
Resident MainTable; //I derive all values from the MainTable, which I will subsequently drop
//Aggregate table - I want to group all CashFlowsTempTable_Data2:
Sum([CashFlow]) as CashFlow
Group By Company, Account, Date;
Drop Table TempTable_Data;
//As per the instruction from the link belowNewTable:
If( Account=Peek(Account), // if the Account is the same as in the previous row
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 ;
Go to Solution.
will be concatenated implicitly to TempTable_Data because they share 100% identical field names...
View solution in original post
between the loads.
I should have asked at start
Spent half of the day playing with the script )
At least I mastered it.
meanwhile I write concatenate / noconcatenate explicitly between every load.