Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I'm new to Qlikview and i'm trying to put an expression in the load script. The expression is used as a scoring mechanism. I have broken it down line by line below to make it clearer. The problem is that any line of the expression that contains 'and' doesn't return a value. I'm clearly missing something obvious but for the life of my i can't work it out! Your help would be really appreciated!
if (len(Material_Name)>0 and len(litTitle)>0 and ApprovalStatus='Approved',10,
if (len(Material_Name)>0 and len(litTitle)>1,9,
if (len(Material_Name)>0 and ApprovalStatus='Approved',8,
if (len(Material_Name)>0,7,
if (len(litTitle)>0 and ApprovalStatus='Approved',6,
if (len(litTitle)>0 ,5,
if (ApprovalStatus='Approved',4,0 )))))))) as [Behaviour Score]
Thanks in advance to anyone who can help!!
Danny
Hi,
I think before Massimo I detected that issue that but never mind I hope you get what you desired.
Regards
André Gomes
Yes you did, i missed that. Thank you Andre.