Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

spividori
Valued Contributor

Set Analysis

Hi.

I need change from formula to Set Analysis:

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

Regards.

Sandro.

1 Solution

Accepted Solutions
perumal_41
Valued Contributor II

Re: Set Analysis

Sandro,

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

Regards

Perumal A

6 Replies
Not applicable

Re: Set Analysis

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

Re: Set Analysis

Hi

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

Hope it helps

spividori
Valued Contributor

Re: Set Analysis

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.

mov
Esteemed Contributor III

Re: Set Analysis

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
Valued Contributor II

Re: Set Analysis

Sandro,

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

Regards

Perumal A

spividori
Valued Contributor

Re: Set Analysis

Hi Perumal A

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

Regards.

Sandro.

Community Browser