Points scale based on clients

[venkatg6759]

Hello Everyone,

Is there any method that we can implement in qlikview to show points score .

We have more than 100 clients which rank analyst based on points.

Ex: Fidelity        30 points              Grade 1

      UBS            150points              Grade 1

Points scale is based on client.Each client has its own grading criteria.

Can we do a calculation based on client to get the analyst grades.

We achieved this in excel by taking each client points are converting them to grades.But can we do this in qlikview without wrtiting the clients since we have more than 100 and can't create something like if(Client=Fidelity and score=30 points,Grade 1)

Any other approach?

Thanks,

Venkata

[arsal_90]

Can you provide me your sample file

[venkatg6759]

I don't have any sample data. I just need an idea .Is this possible or not .

Each client give points to analysts depending on thier grading criteria.

if UBS gave 150 points and fidelity gave only 30 points it doesn't mean that both fall under different grades.

[arsal_90]

if i understand your question. So You can use the the lookup table in which you put the points and their grading and link that table to your client table where actual Points has exist. And then use Interval match function. i will attached sample app for you.