Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Badzreyes00
Contributor III
Contributor III

Average Daily Balance

Hi Everyone!

I don't know if I search the community enough but PLEASE help or advise on how to get the AVERAGE DAILY BALANCE in a transactional table.

For this I think I need 3 new fields in my table, kindly see below for the sample table with 1 customer record and the expected output in bold and red fonts

cust_notrxn_datebalanceADB_DateADBCurrent_ADB
100311-Jan-2001-Jan-200890.33
100312-Jan-201002-Jan-2050890.33
100313-Jan-203453-Jan-20148.3890.33
100314-Jan-20504-Jan-20123.75890.33
100315-Jan-2005-Jan-2099890.33
100316-Jan-2006-Jan-2082.5890.33
100317-Jan-205607-Jan-20150.71890.33
100318-Jan-204008-Jan-20181.88890.33
100319-Jan-208009-Jan-20250.56890.33
1003110-Jan-20120010-Jan-20345.5890.33
1003111-Jan-20150011-Jan-20450.45890.33
1003112-Jan-20170012-Jan-20554.58890.33
1003113-Jan-20013-Jan-20511.92890.33
1003114-Jan-20320014-Jan-20703.93890.33
1003115-Jan-20350015-Jan-20890.33890.33

 

I plan to do this in the script and guessing I could use peek here? but I am really in the dark on how to maximize that function with this requirement. Really appreciate your help! Thank you!

0 Replies