topic Set Analysis in QlikView

Set Analysis

spividori — Mon, 10 Sep 2012 20:57:08 GMT

Hi.

I need change from formula to Set Analysis:

if(Sum(quantity)>0,Sum(quantity),0)

Regards.

Sandro.

Mon, 10 Sep 2012 20:59:48 GMT

Sum({$<Quantity={'>0'}>}Quantity)

MayilVahanan — Mon, 10 Sep 2012 21:03:38 GMT

Sum({$<quantity={">0"}>}quantity)

Hope it helps

spividori — Mon, 10 Sep 2012 21:19:04 GMT

Hi.

Thanks for responding.

But I need add when the sum of quantity is greater than zero.

I go up examples for more understanding.

Regards.

Sandro.

Anonymous — Mon, 10 Sep 2012 23:56:00 GMT

Sandro,

It is not for a set analysis. Using "if" is fine, or you can use this:

rangemax(sum(quantity),0)

Regards,

Michael

perumal_41 — Tue, 11 Sep 2012 04:38:23 GMT

Sandro,

i have attached one application .please check this meet your requirement.

Regards

Perumal A

spividori — Tue, 11 Sep 2012 13:31:16 GMT

Hi Perumal A

Thank you very much, that's what I needed.

Regards.

Sandro.