Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Question on Count - COUNT(DISTINCT (IF (SALES - PLAN) < 500) PRODUCT)

I want to do a distinct count if the Sales - Plan < 500 as I have duplicate records in the data

COUNT(DISTINCT  (IF (SALES - PLAN) < 500) PRODUCT) ?

1 Solution

Accepted Solutions
mwoolf
Honored Contributor II

Re: Question on Count - COUNT(DISTINCT (IF (SALES - PLAN) < 500) PRODUCT)

COUNT(DISTINCT  IF (SALES - PLAN < 500, PRODUCT))

4 Replies
mwoolf
Honored Contributor II

Re: Question on Count - COUNT(DISTINCT (IF (SALES - PLAN) < 500) PRODUCT)

COUNT(DISTINCT  IF (SALES - PLAN < 500, PRODUCT))

Re: Question on Count - COUNT(DISTINCT (IF (SALES - PLAN) < 500) PRODUCT)

Or this:

Count(DISTINCT {<PRODUCT = {"=SALES - PLAN < 500"}>} PRODUCT)

Not applicable

Re: Question on Count - COUNT(DISTINCT (IF (SALES - PLAN) < 500) PRODUCT)

Thanks for the quick response.

Not applicable

Re: Question on Count - COUNT(DISTINCT (IF (SALES - PLAN) < 500) PRODUCT)

Thanks for the quick response.