"And" statement not working in load script expression.

[#1]

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

[agomes1971]

Hi,

I think before Massimo I detected that issue that but never mind I hope you get what you desired.

Regards

André Gomes

[#3]

Yes you did, i missed that. Thank you Andre.