Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Contributor II

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!