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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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