Autogenerate records with a condition

[Kwame]

Hi Everyone,

With reference to the below sample, I wish to create subsequent records where the 'Transaction Date ' changes, and the 'Interest at the End'  (divided by 365) will automatically be added to the 'Interest Accrued'  for each  'Unique ID' after every refresh.

Transaction Date	UniqueID	Interest Accrued	Interest at the end
24/03/2022	100023	2704.73	26681.77
24/03/2022	112345	357.09	645.25
24/03/2022	123889	3145.36	5857.45
24/03/2022	167089	4014.98	8052
24/03/2022	15788	8362.86	21960

Essentially it should look like this: i.e. for ID = 100023

Transaction Date	UniqueID	Interest Accrued	Interest at the end
25/03/2022	100023	2777.83074	26681.77

Many thanks.

[abhijitnalekar]

Hi @Kwame ,

Can you please share the expression or logic? How you derived 2777.83074.

[Kwame]

For this very ID = 100023,  on 24/03/2022 Interest at the end is 26681.77 divided by 365 days =  73.10 (daily interest)

So now on 25/03/2022, daily interest which is 73.10 plus the previous day's accrued interest  2704.73 =  2,777.83

[Kwame · Accepted solution]

Solution was found here;

https://community.qlik.com/t5/Qlik-Design-Blog/How-to-populate-a-sparsely-populated-field/ba-p/14706... or this technical brief: https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394