Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
nhoover
Luminary
Luminary

Convert Access IIF to Qlik Sense

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!

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi

You can try with "If" statement like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

Hi

You can try with "If" statement like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
nhoover
Luminary
Luminary
Author

Thanks so much Mayil