Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Count the returning days?

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 😃

Frequency.png

4 Replies
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)


talk is cheap, supply exceeds demand
sunny_talwar

This might also work as the calculated dimension, right?

=Aggr(Count(Name), Name)

johnw
Champion III
Champion III

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.

Not applicable
Author

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 😃