4 Replies Latest reply: May 8, 2018 7:17 AM by Shakeeb Mohammed RSS

    Calculation - Rating a Percentage as a Score

    Shakeeb Mohammed

      Hi Guys,

       

      I'm hoping someone can help me with a calculation in my script.

       

      My data has percentages varying from 40% - 100% which is a score for an individual please see below.

      DriverGreen Band %
      Driver 1

      90.04%

      Driver 280.04%
      Driver 3

      64.99%

       

      I'm trying to insert a calculation that will give a rating to drivers

       

      Example

      • 40 - 50 % = G
      • 50- 60% = E
      • 60-70% = D
      • 70-80% =C
      • 80-90% =B
      • 90-100% = A

       

      My aim is to then add a field that will give a driver their score and report summing the amount of drivers in category A,B,C etc.

       

      I'm using QlikSense - Thank you in advance!