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.

Driver	Green Band %
Driver 1	90.04%
Driver 2	80.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!

[adityaakshaya]

Hi Shakeeb,

As per my understanding, Intervalmatch can help you to achieve this.

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

Regards,

Akshaya

[sunny_talwar]

Look here

Buckets

[Gabriel]

Hi,

Can I suggest you use MAPPING table and APPLYMAP(). See below snippets

Map_DriversGreenBand:

MAPPING LOAD

       Start + ITERNO()-1                AS MapFrom,

       Banding                                  AS MapTo

INLINE [

Start,        End,   Banding

40,            50,      G

51,            60,      E

61,            70,      D

71,            80,      C

81,           90,       B

91,           100,      A

]

WHILE Start+ ITERNO()-1 <= End;

// then in your table where the driver's grade is

table:

LOAD

fld1,

fld2,

APPLYMAP('Map_DriversGreenBand',GreenBand%,NULL())          AS      [WhateverFieldName]

RESIDENT tmpTableOrWhatever;

Let me know if this helps

[shakeeb_mohammed]

Hi Thanks for the reply and apologies for the delayed response.

I have successfully loaded the script but it shows no Data.

the only thing  I didn't do is use the Resident script. - could you specify what table i will need to Resident please.