Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi
You can try with "If" statement like below
If([Account_Name] ='Internal', If([customertime] = 0, 'Customer', 'Internal'), 'Customer') AS CustomerOrInternal
Hi
You can try with "If" statement like below
If([Account_Name] ='Internal', If([customertime] = 0, 'Customer', 'Internal'), 'Customer') AS CustomerOrInternal
Thanks so much Mayil