Convert Access IIF to Qlik Sense

[nhoover]

Simple problem, I'm trying to convert an access IIF statement in a Qlik Sense Load Script.

IIf([Account_Name] ="Internal", IIf([customertime] = 0, "Customer", "Internal"), "Customer") AS CustomerOrInternal

Thanks for taking the time!

[MayilVahanan · Accepted solution]

Hi

You can try with "If" statement like below

If([Account_Name] ='Internal', If([customertime] = 0, 'Customer', 'Internal'), 'Customer') AS CustomerOrInternal

[nhoover]

Thanks so much Mayil