Hello Qlik Community,
I have files that I load in every day. Each file contains a production date and a list of balances going all the way down the list and an account number. What I need to do is find the average and store that value in a column. I also need to store the account numbers with the maximum 3 balances and the 3 min balances in a column. Any help would be greatly appreciated.
Thank you!