Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
alexcastorena
New Contributor III

Distinct customer count when sales are greater than 0

Hello,
Hopefully you can help. I'm trying to get a distinct customer count where the sales are > 0.

Here's my set analysis

Count(Distinct{<Sales = {">0"}> } CustomerNumber)

Thanks,

Alex

 

 

1 Solution

Accepted Solutions
alexcastorena
New Contributor III

Re: Distinct customer count when sales are greater than 0

Ok Thank You,

I'll try it.

4 Replies

Re: Distinct customer count when sales are greater than 0

Perhaps this?
Count(Distinct {<Sales = {"=Sum(Sales)>0"}> } CustomerNumber)
santhiqlik
New Contributor III

Re: Distinct customer count when sales are greater than 0

I hope this should work !!

Count({<CustomerNumber= {"=Sum(Sales)>0"}> }Distinct  CustomerNumber)

alexcastorena
New Contributor III

Re: Distinct customer count when sales are greater than 0

Ok Thank You,

I'll try it.

alexcastorena
New Contributor III

Re: Distinct customer count when sales are greater than 0

Thanks for the feedback
I'll check it out

Community Browser