topic Re. :Set analysis problem in QlikView

Set analysis problem

sergio — Wed, 23 Feb 2011 14:25:33 GMT

Hello to all:

I have a problem with set analysis again. I have the next expression on a pivot table:


sum({$<ORDER={"$(=max(ORDER))"}>} I_CANT_TRANSMITIDOS)

This expression gets the last value of I_CANT_TRANSMITIDOS, but i need to add a new condition, i need to get the last value if I_CANT_TRANSMITIDOS <> o. I tried:


sum({$<ORDER={"$(=if(I_CANT_TRANSMITIDOS<>0,max(ORDER)))"}>} I_CANT_TRANSMITIDOS)

and


sum({$<~I_CANT_TRANSMITIDOS={0},ORDER={"$(=max(ORDER))"}>} I_CANT_TRANSMITIDOS)

but it doesn't works, how can i add the condition to the set analysis.

Thanks to all in advance.

Re. :Set analysis problem

martin59 — Wed, 23 Feb 2011 14:58:33 GMT

Hi,

Try this expression, it should be works :

sum({$<ORDER={"$(=max(ORDER))"},I_CANT_TRANSMITIDOS={">0"}>} I_CANT_TRANSMITIDOS)

Hope that helps you

Re. :Set analysis problem

sergio — Wed, 23 Feb 2011 15:33:25 GMT

Thanks Martin, but it doesn't work. It gave me the sum of I_CANT_TRANSMITIDOS for the max ORDER but not considered the I_CANT_TRANSMITIDOS > 0...

Re. :Re:Re. :Set analysis problem

martin59 — Mon, 28 Feb 2011 14:23:15 GMT

Hi,

Not sure but you can try something like that :

sum({$<ORDER={"$(=max({<I_CANT_TRANSMITIDOS={">0"}>} ORDER))"}>} I_CANT_TRANSMITIDOS)