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

Hi,

Try like below

count(distinct Customers)

Capture.JPG

Creator III
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
Master II

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

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

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

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

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

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

Master III
Master III

Hi,

Try this

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

Regards,

Antonio