Qlik Community

QlikView Expressor

Discussion Board for collaboration related to QlikView Expressor.

el_lloydie
New Contributor III

Weighted Scores Help

Good morning folks,

I am trying to create a weighted score based on the attached.

Scores 1 and 3 should make 20% each of the overall, with Score 2 making up 60% of the overall. On the attached I just have a simple average sitting in the overall column but that clearly works on the proviso that scores 1-3 are all weighted equally.

I have tried altering my overall expression to include the multiplying of scores 1 and 3 by 0.2 and score 2  by 0.6 but it wasn't working.

Can anyone help me work out what I need to do to get the desired result?

Many thanks

Gareth

2 Replies
jmvilaplanap
Valued Contributor

Re: Weighted Scores Help

Hi

Probably you QV is reading the values as text, then is not possible to multiply. Try to read it as a number.

You can use the num# function: Num# ‒ QlikView

Regards

el_lloydie
New Contributor III

Re: Weighted Scores Help

Hi all,


I managed to get half way there with is using the below expression:

((Overall PO Score % *0.2)

+

(Overall Invoicing Score % *0.6)

+

(Overall Pay Score% *0.2))

This for the large part works, until one or more of the above scores is populated with a "-" due to not having any corresponding data. Any ideas on how I can amend my expression to mitigate the "-"?

I was thinking of replacing the "-" with either 100 or  0, but it's going to bump up or down their weighted score which would then be inaccurate.

Many thanks,

Gareth

Community Browser