topic Re: If condition when two values selected in a select field box in QlikView

If condition when two values selected in a select field box

Fri, 19 Jul 2013 19:28:37 GMT

Hi,

I have this if condition depending on the field GRUPO_MERCADO which is on the sheet:

=if (GRUPO_MERCADO='Internacional' OR GRUPO_MERCADO='Local' OR GRUPO_MERCADO='Gratuidades',0,

-sum({<Facturacion={'Vta.España'}>}SDO_EU_PER))

I would like it makes a '0' even when there is two values selected in the select field box in the sheet.

The OR condition works well but not when there is two values selected.

Thanks

Re: If condition when two values selected in a select field box

CELAMBARASAN — Fri, 19 Jul 2013 20:30:31 GMT

While there is more than one selection in a field you cannot use simply the field to get values. Because it returns you null only. You have to use getFieldSelections or Concat depends upon your need.

Check with this

if(WildMatch(getfieldselections(GRUPO_MERCADO, ';'), 'Internacional', 'Local', 'Gratuidades'), 0, -sum({<Facturacion={'Vta.España'}>}SDO_EU_PER))

Hope it helps

Celambarasan