# New to Qlik Sense

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

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a \$200 Amazon Gift Card! Watch Video
cancel
Showing results for
Did you mean:
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
Master III

Hi,

try this in Text Box

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

Regards,

Antonio

8 Replies
Master II

Hi,

Try like below

count(distinct Customers)

Creator III

Hi Devarasu,

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

Master II

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

Master III

Hi,

try this in Text Box

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

Regards,

Antonio

Creator III

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

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

if i select the following dates,

 3-15-2017 6-20-2017

my output should be

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

Thanks

Creator III

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??

Creator III

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

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.

Master III

Hi,

Try this

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

Regards,

Antonio

Tags