Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.