How to Count the returning days?

[#1]

Hi QlikView Community,

Can you help me finding the count of customers returning. My boss wants me to get the frequency of the returning customers. Thank in advanced 😃

[Gysbert_Wassenaar]

Create a straight or pivot table and use as calculated dimension =aggr(count(distinct [Check In]),Name) and as expression =count(distinct Name)

[sunny_talwar]

This might also work as the calculated dimension, right?

=Aggr(Count(Name), Name)

[johnw]

I believe not if Name connects more than one table together? Otherwise, yes? But I think it's more clear what we're after if we count distinct check ins, even if it's a little more code.

[#5]

Wow, I have an output now, I'll just bash the manual vs qlikview to check if this is accurate. thank you very much sir 😃