Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ulviyya
Contributor II
Contributor II

Count of customers that have values higher than 0

Hello everybody,

I have a problem regarding Count function.

I have data stored in several columns: Year, Month, Customer_no and several Deposit types and need to count a number of distinct customers that have sum of all Deposit types>0. When I write if((Deposit1+Deposit2+Deposit3)>0,count(distinct customer_no))) I get 0.Please help, I have read many topics regarding count but none of them helped me with this issue.

 

Thanks in advance for any replies.

 

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

count(distinct {<customer_no={"=Sum(Deposit1+Deposit2+Deposit3)>0"}>} customer_no)

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

count(distinct {<customer_no={"=Sum(Deposit1+Deposit2+Deposit3)>0"}>} customer_no)

View solution in original post

Ulviyya
Contributor II
Contributor II

It worked!!!  Many thanks!!!