Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unique Customer Visit by (Customer and Date Combination)

Hi All,

I'm trying to calculate the unique customer visit count by combining (Customer and Date)

Suppose if  customer A visited a store on 1/1/2012 for 5 times it will be treated as 1 visit and if customer B visit the store on the same day (1/1/2012) then the total unique visit is 2.

Unique Visit.PNG

In my calculation , Unique visit is calculating as 4 instead of 5.  (1/1/2012,3/4/2012,5/3/2012,12/3/2012 (Customer A),12/3/2012 (Customer B).

So, totall unique visity should come as 5 instead of 4. How to calculate the same?

Thanks,

Selva

1 Solution

Accepted Solutions
kaushiknsolanki

Hi,

     Try this expression.

     sum(aggr(Count(DISTINCT Date),Customer))

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
somenathroy
Creator III
Creator III

Hi,

Use the expression : Count (DISTINCT Date & Customer)

Regards,

som

kaushiknsolanki

Hi,

     Try this expression.

     sum(aggr(Count(DISTINCT Date),Customer))

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

Thanks Som/Kaushik,

Both of you solution worked...

Selva