Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

Re: Using Combined Or (+) in Set Analysis

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

Re: Using Combined Or (+) in Set Analysis

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

thanks

regards

Marco