topic Re: Replace multiple IFs statement by IF list contains in QlikView

Replace multiple IFs statement by IF list contains

Sun, 13 Jul 2014 20:02:55 GMT

In a calculated dimension for a pivot table, I would like to test the condition

IF(MyField in ['A','B','C','D'])

For now, I am doing

IF(MyField = 'A' OR MyField = 'B' OR MyField = 'C' OR MyField = 'D', ..., ...)

Since expression for MyField is heavy, I would like to replace this by a more efficient syntax, such as search in a list (like a contains() method in other languages). Is there such a syntax?

Thanks in advance!

Re: Replace multiple IFs statement by IF list contains

its_anandrjs — Sun, 13 Jul 2014 20:13:15 GMT

You can try match function also

Ex:-

=IF( Match( MyField,'A','B','C','D' ))

Re: Replace multiple IFs statement by IF list contains

Sun, 13 Jul 2014 20:37:15 GMT

is =IF( Match( MyField,'A','B','C','D' ),...,...) strictly equivalent to IF(MyField = 'A' OR MyField = 'B' OR MyField = 'C' OR MyField = 'D', ..., ...) ?

Re: Replace multiple IFs statement by IF list contains

its_anandrjs — Sun, 13 Jul 2014 20:51:10 GMT

Yes you are right or may be you can use Index() function for this.