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: 
alexcastorena
Contributor III
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
Contributor III
Contributor III
Author

Ok Thank You,

I'll try it.

View solution in original post

4 Replies
Anil_Babu_Samineni

Perhaps this?
Count(Distinct {<Sales = {"=Sum(Sales)>0"}> } CustomerNumber)
Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
santhiqlik
Creator
Creator

I hope this should work !!

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

alexcastorena
Contributor III
Contributor III
Author

Ok Thank You,

I'll try it.

alexcastorena
Contributor III
Contributor III
Author

Thanks for the feedback
I'll check it out