New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

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!

Tags (5)
4 Replies
Contributor III

Re: Calculation - Rating a Percentage as a Score

Hi Shakeeb,

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

Regards,

Akshaya

MVP

Re: Calculation - Rating a Percentage as a Score

Look here

Buckets

Valued Contributor II

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

New Contributor II

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.