topic Points scale based on clients in QlikView

Points scale based on clients

venkatg6759 — Thu, 19 Jun 2014 15:39:56 GMT

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

Re: Points scale based on clients

arsal_90 — Thu, 19 Jun 2014 15:47:42 GMT

Can you provide me your sample file

Re: Points scale based on clients

venkatg6759 — Thu, 19 Jun 2014 15:51:23 GMT

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.

Re: Points scale based on clients

arsal_90 — Thu, 19 Jun 2014 16:00:56 GMT

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.