4 Replies Latest reply: Sep 3, 2018 4:50 AM by Muhammad Hazim Muhammad Alif RSS

    Adding sum or avg in dummy field

    Muhammad Hazim Muhammad Alif

      Hello everyone,

       

      I have a problem where i cannot find a way to add sum/avg in dummy value

      Below is the table.

       

      Qlik community 5.PNG

      Notes: RANK  No 30 and Factory Average is the dummy value i've created in the load script.


      Question:

      Is it possible to assign the AVG(Total Uptime) for Rank 1, 2 and 3 IN Rank 30 Total Uptime??


      Need your help everyone


      Thank you for your time

      &

      Thank You in Advance!