Creating A KPI based on volume

[David_K]

Good afternoon fellow Qlik Sense Users,

I would like to create a KPI based on the count of a product sales to customers based on a distinct customer reference.  Effectively I want to see the number of customers purchasing the products

I have 2000 product lines, with 375 customers from which only 250 customers have purchased products in a given period, and the number i want to display is 250. This will obviously vary based on the time period selected.

I have tried various configurations of the following but keep coming up with errors

IF(count(ProductName > 0), count(distinct CustomerNo)) 

Is there anyone who can provide some guidance on this.

Thanks in advance,

David

[anat]

IF(count(ProductName) > 0, count(distinct CustomerNo))

[TauseefKhan]

Hi @David_K,

Check this:
count(distinct {<QuantitySold={">0"}>} CustomerNo)

[David_K]

Hi Anat,  Thanks for the reply, unfortunately is still returning the total number of customers  including those with 0  - I have tried changing '>0' to '>=1' but still get the same response.  Any additiona lideas?

Thanks, David 

[David_K]

Hi TauseefKhan,  Thanks for the rely, unfortunately the above returns a customer count of '0'.

 I have tried changing '>0' to '>=1' but still get the same response.  Any additiona lideas?

Thanks, David