topic Re: How to Count the returning days? in QlikView https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203221#M874827 <HTML><HEAD></HEAD><BODY><P>Create a straight or pivot table and use as calculated dimension =aggr(count(distinct [Check In]),Name) and as expression =count(distinct Name)</P></BODY></HTML> Tue, 01 Nov 2016 16:58:29 GMT Gysbert_Wassenaar 2016-11-01T16:58:29Z How to Count the returning days? https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203220#M874826 <HTML><HEAD></HEAD><BODY><P>Hi QlikView Community,</P><P></P><P>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 <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P><IMG alt="Frequency.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/142595_Frequency.png" style="height: auto;" /> </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203220#M874826 2020-11-25T16:16:04Z Re: How to Count the returning days? https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203221#M874827 <HTML><HEAD></HEAD><BODY><P>Create a straight or pivot table and use as calculated dimension =aggr(count(distinct [Check In]),Name) and as expression =count(distinct Name)</P></BODY></HTML> Tue, 01 Nov 2016 16:58:29 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203221#M874827 Gysbert_Wassenaar 2016-11-01T16:58:29Z Re: How to Count the returning days? https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203222#M874829 <HTML><HEAD></HEAD><BODY><P>This might also work as the calculated dimension, right?</P><P><STRONG>=Aggr(Count(Name), Name)</STRONG></P></BODY></HTML> Tue, 01 Nov 2016 18:03:19 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203222#M874829 sunny_talwar 2016-11-01T18:03:19Z Re: How to Count the returning days? https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203223#M874831 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 01 Nov 2016 18:56:24 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203223#M874831 johnw 2016-11-01T18:56:24Z Re: How to Count the returning days? https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203224#M874833 <HTML><HEAD></HEAD><BODY><P>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 <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P></BODY></HTML> Wed, 02 Nov 2016 02:43:27 GMT https://community.qlik.com/t5/QlikView/How-to-Count-the-returning-days/m-p/1203224#M874833 2016-11-02T02:43:27Z