0 Replies Latest reply: Aug 15, 2018 9:50 PM by Muhammad Hazim Muhammad Alif RSS

    Ranking in Pivot Table (Qlik Sense)

    Muhammad Hazim Muhammad Alif

      Hello everyone,

       

      I have a problem where I have to make a pivot table that looks exactly like this .

      Qlik Community.PNG

      In the raw file, The data looks like this

      Qlik Community 2.PNG

      Requirement :

      1) Ranking is calculated based on the total uptime

      2) The 1st priority is the output should be as the first image

       

      Calculation :

      Total uptime % = (Actual uptime / target uptime) * 100

      Total Output = (Actual output/ target output) * 100

      Rank (sum((Actual uptime / target uptime) ))

       

      My problem right now :

      1) Daily ranking is not exist and unavailable to be put as dimension

      2) Factory should logically be the dimension in the pivot table

      3) Pivot table in qlik sense cannot be sorted by measure

       

      My current solution :

      Qlik Community 3.PNG

      I ranked it using the rank formula. I have not found any other solution so far.

       

      Can someone help me solve this problem? or is it impossible?

       

      Thank you in advance!