# 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
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.

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

Hi,

Try this expression.

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

Regards,

Kaushik Solanki

Regards,
Kaushik
3 Replies
Creator III

Hi,

Use the expression : Count (DISTINCT Date & Customer)

Regards,

som

Hi,

Try this expression.

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

Regards,

Kaushik Solanki

Regards,
Kaushik