topic Re: Multiple values in a Load Statement in QlikView

Multiple values in a Load Statement

Anonymous — Fri, 20 Jan 2017 16:34:09 GMT

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

sunny_talwar — Fri, 20 Jan 2017 16:55:25 GMT

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 — Mon, 30 Jan 2017 13:49:58 GMT

Thank you Sunny T- that worked!