Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Multiple values in a Load Statement

Current Load Statement is working properly,

if([Incident Related to Interaction Flag]='y',if([Incident Opened by Email Name]='HPOO','User'))as [User or Non-User Generated2]

but I need to add another search value to the [Incident Opened by Email Name] part of it and I cannot get it to work. 

I need it to check if:

[Incident Opened by Email Name] = 'HPOO' OR '*@*'(any email address)

[Incident Related to Interaction Flag]= 'y'

Output= 'User'


Thanks!

Dan

2 Replies
sunny_talwar

May be this:

If([Incident Related to Interaction Flag]='y',

If(WildMatch([Incident Opened by Email Name], 'HPOO', '*@*'), 'User')) as [User or Non-User Generated2]

Anonymous
Not applicable
Author

Thank you Sunny T- that worked!