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: 
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!

Labels (1)
2 Replies
swuehl
Champion III
Champion III

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

MarcoWedel
MVP
MVP

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

thanks

regards

Marco