Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Husky_Bab12
Contributor
Contributor

Using two conditions in set analysis

Hi,

I'm trying to implement two conditions in set analysis as below,

=sum({<[Arrived Run Total]={">=0"} , [RunTot_Quantity]={"<0"}>} Quantity).

I need to sum all the quantities when the corresponding [Arrived_run Total] >=0 and [RunTot_Quantity]>0.

I'm trying to do it but unable to achieve the expected result.

I'm just able to add the quantities which has [Arrived Run Total] >=0 leaving out quantites which has [RunTot_quantity]>0.


Can someone help here?


Labels (2)
10 Replies
Husky_Bab12
Contributor
Contributor
Author

Yes, I negative value sums are expected. With the above formula I can get positive value sums.