topic Re: Nested IF in QlikView

Nested IF

kev6brown — Fri, 30 Jun 2023 11:41:29 GMT

I'm looking to create a dimension in a table using an IF statement but it's not working. So I have -

IF FeedType <> 'OUTS' and RefDesc ='PSCD*' or 'PHCD*' or 'PHTD', 04,

IF Feedtype = 'OUTS' OR RefDesc= 'HICD*', '05'

What am I doing wrong?

Re: Nested IF

Mark_Little — Fri, 30 Jun 2023 12:04:12 GMT

When you do an OR you do have to define the field again or use the Match() function. i.e.

IF RefDesc='x' or RefDesc='y'..

Might be worth reviewing the wildmatch() function also.

Re: Nested IF

AL07 — Fri, 30 Jun 2023 12:08:24 GMT

Can you elaborate your requirement as if you need any of the following values?
RefDesc ='PSCD*' or 'PHCD*' or 'PHTD' ALSO Feedtype = 'OUTS' OR RefDesc= 'HICD*', '05' - Wether it is "or" or "And"

After clearing your posted statement try this:

=IF (FeedType <> 'OUTS' and RefDesc ='PSCD*' or 'PHCD*' or 'PHTD', 04,
IF (FeedType = 'OUTS' OR RefDesc= 'HICD*', '05'))

Thanks!!

Re: Nested IF

BrunPierre — Fri, 30 Jun 2023 17:26:23 GMT

@kev6brown As below.

If(not Match(FeedType,'OUTS') and WildMatch(RefDesc,'PSCD*','PHCD*','PHTD'), 04,
If(Match(FeedType,'OUTS') or WildMatch(RefDesc,'HICD*'), 05, Null()))