topic Re: Indirect Set Analysis in QlikView

Indirect Set Analysis

Fri, 19 Oct 2012 14:55:05 GMT

Hello,

I need some help

I want to get customer for the current selection but I want exclude customer who bought and item and cutomer who bought items from a brand.

Expression 1:

Sum({$<COD_TARJETA-=p({1<COD_ART={$(Articulo_excluir)}>}COD_TARJETA)>}IMP_VTA_LINEA)

Expression 2:

Sum({$<COD_TARJETA-=p({1<COD_MARCA={$(Marca_excluir)}>}COD_TARJETA)>}IMP_VTA_LINEA)

COD_TARJETA = Customer

COD_ART = Item

Articulo_excluir=Item to exclude

IMP_VTA_LINEA=Sales

COD_MARCA=Brand

Marca_excluir= Brand to exclude

Every expression works fine.

But get both exclusion in only one expression does not work. I use:

=Sum({$<COD_TARJETA-=P({1<COD_MARCA={$(Marca_excluir)}>}COD_TARJETA),COD_TARJETA-=P({1<COD_ART={$(Articulo_excluir)}>}COD_TARJETA)>}IMP_VTA_LINEA)

Any idea

Thanks

swuehl — Fri, 19 Oct 2012 18:28:05 GMT

You have two different set modifiers for field COD_TARJETA, this will not work as expected.

Try like

=Sum( {$<

COD_TARJETA =

COD_TARJETA -

(

P({1<COD_MARCA={$(Marca_excluir)}>}COD_TARJETA)

+ P({1<COD_ART={$(Articulo_excluir)}>} COD_TARJETA)

)

>} IMP_VTA_LINEA)

Mon, 22 Oct 2012 08:36:49 GMT

Thanks swuehl

It works

So simple...