Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
BOYERWMAP
Contributor III
Contributor III

Add scoring fields based on values of fields from data load editor to sum for a final score

I need to score leads in a qlik app.  There's a table of attributes I need to score individually by adding score fields and ultimately sum them for a "lead score".

How do I add these fields in the script?

For example.. I need to say 

If(Match[Characteristic Name Desc],'Ar-Argon') And [Characteristic Value]='1010',5,0 As [Argon Score]

However when I add this to the end of my load fields, it doesn't put a 5 in Argon Score for every lead with an account that contains Argon-Yes in my results.  

I'm doing something wrong...

1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

There are some syntax errors in what yo have posted, is that exactly what you have in your app?

Have you tried building the expression in a table in the UI to test syntax and logic before moving into the script?

Cheers,

Chris.