topic Re: Multiple IF statements in QlikView

Multiple IF statements

Wed, 02 Oct 2013 14:02:04 GMT

Hi everyone,

looking for some help with IF statements. Basically I would like to setup multiple "if conditions" in one expression... but I cannot seem to get it to work.

Example:

if(WildMatch(UNIT_TYPE,'*I*'), UNIT_TYPE) or

if(WildMatch(UNIT_TYPE,'*O*'), UNIT_TYPE) or

if(WildMatch(UNIT_TYPE,'*E*'), UNIT_TYPE)

Even if I replace "or" with "and" it does not work. Any ideas on how I can do this?

Re: Multiple IF statements

Anonymous — Wed, 02 Oct 2013 14:04:16 GMT

Try this...

if(WildMatch(UNIT_TYPE,'*I*') or WildMatch(UNIT_TYPE,'*O*') or WildMatch(UNIT_TYPE,'*E*'), UNIT_TYPE)

Re: Multiple IF statements

jonathandienst — Wed, 02 Oct 2013 14:11:52 GMT

If(WildMatch(UNIT_TYPE,'*I*', '*O*', '*E*'), UNIT_TYPE)

Jonathan

Re: Multiple IF statements

jagan — Wed, 02 Oct 2013 14:23:15 GMT

Hi,

Try this

if(WildMatch(UNIT_TYPE,'*I*', '*O*', '*E*'), UNIT_TYPE)

Hope this helps you.

Regards,

Jagan.

Re: Multiple IF statements

Wed, 02 Oct 2013 15:36:03 GMT

Thank you everyone!