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.
