Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

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

Highlighted

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

thanks

regards

Marco