Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Two data fields > 0 (Set Analysis)

Hi,


Trying to put together two (or more) fields added together which are greater than 0 to give a result.

The set analysis so far for a single field:

COUNT({$<SALES_TOTAL={">0"}>}  SALES_TOTAL)

It's probably something really simple, can't seem to find it anywhere.


Thanks.

5 Replies
sunny_talwar

What is the other field?

Not applicable
Author

Other field is named: SALES_TOTAL_2

Exactly the same sort of field, just another number.

sunny_talwar

How about this:

Count({$<SALES_TOTAL={">0"}>+<SALES_TOTAL_2={">0"}>}  SALES_TOTAL)

Not applicable
Author

Great stuff, one problem.

It brings back more than it should.

If I wanted to exclude other records from interfering with the set analysis, is there a way to exclude other fields like this?


Thanks.

sunny_talwar

Exclude other fields? Can you elaborate a little because I am not sure I understand your question