topic Re: How to retrieve records that has multiple record in QlikView https://community.qlik.com/t5/QlikView/How-to-retrieve-records-that-has-multiple-record/m-p/543592#M203119 <HTML><HEAD></HEAD><BODY><P>May be like this?</P><P>Calculated dimension: =If(Aggr(Count(CustID), date_of_Visit)&gt;1,CustID)</P></BODY></HTML> Fri, 20 Sep 2013 04:39:05 GMT tresB 2013-09-20T04:39:05Z How to retrieve records that has multiple record https://community.qlik.com/t5/QlikView/How-to-retrieve-records-that-has-multiple-record/m-p/543590#M203117 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have assigned a primary key ID for individual customer. My table dimension will be Cust_ID, Date_of_Visit with an expression of sum(Revenue)</P><P></P><P>For my table, I would want to show all those customer who visited more than one time in Date_of_Visit field</P><P></P><P>How can i do it?</P><P></P><P>I would want to eliminate records that has only one record for date of visit with one cust ID</P></BODY></HTML> Fri, 20 Sep 2013 03:12:28 GMT https://community.qlik.com/t5/QlikView/How-to-retrieve-records-that-has-multiple-record/m-p/543590#M203117 n1ef5ng1 2013-09-20T03:12:28Z Re: How to retrieve records that has multiple record https://community.qlik.com/t5/QlikView/How-to-retrieve-records-that-has-multiple-record/m-p/543591#M203118 <HTML><HEAD></HEAD><BODY><P>My date of visit is a date field/</P></BODY></HTML> Fri, 20 Sep 2013 03:17:20 GMT https://community.qlik.com/t5/QlikView/How-to-retrieve-records-that-has-multiple-record/m-p/543591#M203118 n1ef5ng1 2013-09-20T03:17:20Z Re: How to retrieve records that has multiple record https://community.qlik.com/t5/QlikView/How-to-retrieve-records-that-has-multiple-record/m-p/543592#M203119 <HTML><HEAD></HEAD><BODY><P>May be like this?</P><P>Calculated dimension: =If(Aggr(Count(CustID), date_of_Visit)&gt;1,CustID)</P></BODY></HTML> Fri, 20 Sep 2013 04:39:05 GMT https://community.qlik.com/t5/QlikView/How-to-retrieve-records-that-has-multiple-record/m-p/543592#M203119 tresB 2013-09-20T04:39:05Z