Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

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
Partner - Specialist II
Partner - Specialist II

Sandro,

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

Regards

Perumal A

View solution in original post

6 Replies
Not applicable

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

MayilVahanan

Hi

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

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
spividori
Specialist
Specialist
Author

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
Not applicable

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
Partner - Specialist II
Partner - Specialist II

Sandro,

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

Regards

Perumal A

spividori
Specialist
Specialist
Author

Hi Perumal A

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

Regards.

Sandro.