0 Replies Latest reply: Jun 29, 2012 1:53 PM by Saurav S RSS

    Combining two variables

      Hello All,

       

      I am trying to work out a metric where I need to derive a level based on two different scores. The first metric IR, receives a point value 1-60. The second metric, AHT, receives a point value 1-40. Then we combine both of these point values to derive a Productivity Score. After getting the productivity score we give a Level 1-5. I have been able to work out the combined productivity score by setting it up as a variable, but I have not been able to get the level. I have attached a sample of Qlikview for futher details.

       

      Example:

       

      AHT = 525

      AHT Points= 36.34

       

      IR=.90

      IR Points= 60

       

      Productivity Score = 36.34 + 60= 96.34

       

      Productivity Level = 5

       

       

      Thank you for all of your time.

       

      Saurav