Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

Tags (2)
1 Solution

Accepted Solutions
cesaraccardi
Valued Contributor

Re: Restrict value with set analysis and OR clause

Hi Mel,

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

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

Kind Regards,

Cesar

2 Replies
cesaraccardi
Valued Contributor

Re: Restrict value with set analysis and OR clause

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

Re: Restrict value with set analysis and OR clause

Hi

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

Should work for you

hope that helps

Joe