Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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 (1)
10 Replies
Husky_Bab12
Contributor
Contributor
Author

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