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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Restrict value with set analysis and OR clause

Hello,

I have the following expression:

=Count({<[Actual Volume]={'>0'}>}%SKU)

This counts SKUs for which there is sales Volume.

I want to add in an OR statement in my set analysis that accounts for production volume

=Count({<[Production Volume]={'>0'}>}%SKU)

How would I combine these two, so that SKUs are counted if there is either sales or production volume?

Thank you

Mel

1 Solution

Accepted Solutions
cesaraccardi
Specialist
Specialist

Hi Mel,

You can use the set operator for union ( + ) to achieve that:

=Count({$<[Actual Volume]={'>0'}>+$<[Production Volume]={'>0'}>}%SKU)

Kind Regards,

Cesar

View solution in original post

2 Replies
cesaraccardi
Specialist
Specialist

Hi Mel,

You can use the set operator for union ( + ) to achieve that:

=Count({$<[Actual Volume]={'>0'}>+$<[Production Volume]={'>0'}>}%SKU)

Kind Regards,

Cesar

Not applicable
Author

Hi

Count({<[Actual Volume]={'>0'}>+<[Production Volume]={'>0'}>}%SKU)

Should work for you

hope that helps

Joe