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: 
jayaseelan
Creator III
Creator III

Find Count of Customers avilable in all date

Hi Expects,

          I need to calculate the no of customers that should available in all selected date. I have attached the sample data. any one can help me to do the task.

Thanks

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi,

try this in Text Box

=Sum(Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))

Regards,

Antonio

View solution in original post

8 Replies
devarasu07
Master II
Master II

Hi,

Try like below

count(distinct Customers)

Capture.JPG

jayaseelan
Creator III
Creator III
Author

Hi Devarasu,

   Thanks for you reply, This is not my output, i should count the customers who all available in all dates.

devarasu07
Master II
Master II

Can you share your expected output for the given data,.tks

antoniotiman
Master III
Master III

Hi,

try this in Text Box

=Sum(Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))

Regards,

Antonio

jayaseelan
Creator III
Creator III
Author

if i select the following dates

 

2-20-2017
2-20-2017
2-23-2017
2-23-2017
3-20-2017
3-20-2017
3-20-2017
3-20-2017
3-15-2017
3-15-2017

my output should be

Capture.PNG

Because in my data customer "A" is available in all dates

Capture.PNG

if i select the following dates,

 

3-15-2017
6-20-2017

my output should be


Capture.PNG

Because in my data customer "A" and "B" is available in selected two dates


Capture.PNG


Thanks

jayaseelan
Creator III
Creator III
Author

hi Antonio,

       Thank you so much, yes this is my output. but one more step i have to do,

I have to plot this value in the date.

is it possible??

jayaseelan
Creator III
Creator III
Author

I have attached my data,

Sum(Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))

from above expression i am getting my output

Capture.PNG

i need to show the result in following way,

by your expression i am getting the result "1" value only at the 1st date  the result "1" should appear in all selected date.

Capture.PNG

antoniotiman
Master III
Master III

Hi,

Try this

=Sum(TOTAL Aggr(If(Count(DISTINCT Date)=Count(TOTAL DISTINCT Date),1),Customers))

Regards,

Antonio