Discussion board where members can get started with Qlik Sense.
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.
I'm trying to insert a calculation that will give a rating to drivers
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!
As per my understanding, Intervalmatch can help you to achieve this.
Can I suggest you use MAPPING table and APPLYMAP(). See below snippets
Start + ITERNO()-1 AS MapFrom,
Banding AS MapTo
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
APPLYMAP('Map_DriversGreenBand',GreenBand%,NULL()) AS [WhateverFieldName]
Let me know if this helps
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.