topic Re: IF function with multiple values in QlikView

IF function with multiple values

Tue, 03 Jul 2012 11:06:49 GMT

I have to write an IF condition like

=IF( (VAR=1 OR VAR=2 OR VAR=3 OR VAR=4 OR VAR=5 OR VAR=6) AND ( FOO=2 OR FOO=3 OR FOO=4 OR FOO=5 OR FOO=6),'A','B')

It works, but exist a quick way to write it? Something like

= IF( (VAR in (1,2,3,4,5,6)) AND (FOO in (2,3,4,5,6),'A','B')

Thanks

rajni_batra — Tue, 03 Jul 2012 11:19:51 GMT

you can use match function for this

match(VAR, 1,2,3,4,5).. and so on..

hope it helps!!!

Tue, 03 Jul 2012 11:24:07 GMT

I try this

=IF(MATCH(VAR,1,2,3,4,5,6),'A','B')

but it does not works...

rajni_batra — Tue, 03 Jul 2012 11:30:21 GMT

Strange check the Test App

Tue, 03 Jul 2012 13:25:07 GMT

Ok, now it work!

Thanks