topic Re: Sintaxis of 'OR' inside a set analysis expression in QlikView

Sintaxis of 'OR' inside a set analysis expression

Wed, 19 Mar 2014 17:19:41 GMT

Hi, I need a set analysis expression wich consider two possible values for the field 'EPIG_CONS'. I tried this but it gives me error in set modifier expression:

=sum({<EPIG_CONS={'Producción Paquete TI (KIP)'} or EPIG_CONS={'Producción Directos (Hotel)'}>}SDO_US_PER)

Please help. Thanks

Re: Sintaxis of 'OR' inside a set analysis expression

jerem1234 — Wed, 19 Mar 2014 17:21:32 GMT

Try:

sum({<EPIG_CONS={'Producción Paquete TI (KIP)', 'Producción Directos (Hotel)'}>}SDO_US_PER)

Hope this helps!

Re: Sintaxis of 'OR' inside a set analysis expression

chiru_thota — Wed, 19 Mar 2014 17:24:34 GMT

Re: OR operator in set analysis