topic Re: Using or condition in if statement in QlikView

Using or condition in if statement

Tue, 12 May 2015 10:05:49 GMT

Hi All,

I wish to use an or condition in the if statement like:

if Value=3 or Value=4 or Value=5 then 'Y'

else 'N'.

How do I convert it into an if statement?

Thanks,

Asma

Tue, 12 May 2015 10:11:26 GMT

Hi Asma,

' If ' Function has 3 Parts

1- Conditon,

2- IF Condition Holds True

4. If Condition doesn't hold Trye / ELSE

Use can try in your case; ( Value considered as a Field name)

IF(Value='3' or Value='4' or Value='5', 'Y'', 'N')

Hope it helps.

Cheers !

Tue, 12 May 2015 10:16:41 GMT

I tried this. But it is not working

Tue, 12 May 2015 10:19:31 GMT

I had done a small syntax error. It works now. Thanks