Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Combined Or (+) in Set Analysis

Hello,

Having trouble figuring out how to do the following:

Count of distinct [ID] where:

A is greater than 0 and select all X

or

B is greater than 0 and select all X

or

C is greater than 0

or

D is greater than 0

Here is what i have so far:

count({<={'>0'},={'*'}> + <={'>0'},={'*'}> + <={'>0'}> + <={'>0'}>} DISTINCT [ID])


the result is actually ignoring the field and when I make the manual selection, I get the accurate count.


Thanks in advance!

2 Replies
swuehl
MVP
MVP

Can you post some sample data / a sample QVW file that demonstrates your issue?

MarcoWedel

please post some sample data and your expected result, best in a qvw.

thanks

regards

Marco