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

# Calculation - Rating a Percentage as a Score

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!

• ###### Re: Calculation - Rating a Percentage as a Score

Hi Shakeeb,

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

Regards,

Akshaya

• ###### Re: Calculation - Rating a Percentage as a Score

Look here

Buckets

• ###### Re: Calculation - Rating a Percentage as a Score

Hi,

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

Map_DriversGreenBand:

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;

table:

fld1,

fld2,

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

RESIDENT tmpTableOrWhatever;

Let me know if this helps

• ###### Re: Calculation - Rating a Percentage as a Score

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.