Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Two data fields > 0 (Set Analysis)

What is the other field?

Not applicable

Re: Two data fields > 0 (Set Analysis)

Other field is named: SALES_TOTAL_2

Exactly the same sort of field, just another number.

MVP
MVP

Re: Two data fields > 0 (Set Analysis)

How about this:

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

Not applicable

Re: Two data fields > 0 (Set Analysis)

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.

MVP
MVP

Re: Two data fields > 0 (Set Analysis)

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

Community Browser