This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
Try this expression.
View solution in original post
Use the expression : Count (DISTINCT Date & Customer)
Both of you solution worked...