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.


      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!