0 Replies Latest reply: Jul 25, 2018 7:51 AM by Hamza Alsalman RSS

    avg balance and max balance for each day

    Hamza Alsalman

      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!