Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

hamza99a
Contributor

avg balance and max balance for each day

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!

Community Browser