topic Re: Filter records in a table chart in QlikView https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626262#M543073 <HTML><HEAD></HEAD><BODY><P>Much better!</P><P></P><P>Is there a way to remove the duplicate entries?</P><P></P><P>Thanks,</P><P>Mike</P></BODY></HTML> Fri, 23 May 2014 14:24:23 GMT marsmike 2014-05-23T14:24:23Z Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626257#M543068 <HTML><HEAD></HEAD><BODY><P>I have a table chart in my app that that has multiple records with the same primary key but with different dates.&nbsp; So it might look like this:</P><P></P><P>14725836&nbsp;&nbsp;&nbsp;&nbsp; 5/20/2014</P><P>14725836&nbsp;&nbsp;&nbsp;&nbsp; 5/21/2014</P><P>14725836&nbsp;&nbsp;&nbsp;&nbsp; 5/23/2014</P><P></P><P>I would like to only display the record with the latest (most recent) date.</P><P></P><P>Is there a way to do that within the table properties?</P><P>Thanks,</P><P>Mike</P></BODY></HTML> Fri, 23 May 2014 13:33:37 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626257#M543068 marsmike 2014-05-23T13:33:37Z Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626258#M543069 <HTML><HEAD></HEAD><BODY><P>I think, you may need to use one of those options:</P><P>- dimension limits,</P><P>- expression like FirstSortedValue()</P><P>- set analysis with rank()</P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Fri, 23 May 2014 13:36:06 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626258#M543069 2014-05-23T13:36:06Z Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626259#M543070 <HTML><HEAD></HEAD><BODY><P>did you try a chart with?</P><P>dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; your primary key field</P><P>expression&nbsp;&nbsp;&nbsp;&nbsp; max(your date field)</P></BODY></HTML> Fri, 23 May 2014 13:37:12 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626259#M543070 maxgro 2014-05-23T13:37:12Z Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626260#M543071 <HTML><HEAD></HEAD><BODY><P>I'm not really good with set analysis.&nbsp; I was hoping for something easier.&nbsp; I tried the dimension on the key field and max(your date field).&nbsp; That gives me the latest date.&nbsp; But I failed to mention that there are multiple primary key records, like this:</P><P></P><P>14725836&nbsp;&nbsp;&nbsp;&nbsp; 5/20/2014</P><P>14725836&nbsp;&nbsp;&nbsp;&nbsp; 5/21/2014</P><P>25836914&nbsp;&nbsp;&nbsp;&nbsp; 5/15/2014</P><P>25836914&nbsp;&nbsp;&nbsp;&nbsp; 5/19/2014</P><P>36914725&nbsp;&nbsp;&nbsp;&nbsp; 5/10/2014</P><P>36914725&nbsp;&nbsp;&nbsp;&nbsp; 5/17/2014</P><P></P><P>So, for each primary key I need the latest date.&nbsp; Sorry for not explaining that.</P><P></P><P>Mike</P></BODY></HTML> Fri, 23 May 2014 13:47:19 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626260#M543071 marsmike 2014-05-23T13:47:19Z Re: Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626261#M543072 <HTML><HEAD></HEAD><BODY><P>like this?</P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59459_1.png" style="width: auto; height: auto;" /></P></BODY></HTML> Fri, 23 May 2014 13:56:11 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626261#M543072 maxgro 2014-05-23T13:56:11Z Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626262#M543073 <HTML><HEAD></HEAD><BODY><P>Much better!</P><P></P><P>Is there a way to remove the duplicate entries?</P><P></P><P>Thanks,</P><P>Mike</P></BODY></HTML> Fri, 23 May 2014 14:24:23 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626262#M543073 marsmike 2014-05-23T14:24:23Z Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626263#M543074 <HTML><HEAD></HEAD><BODY><P>Thoughts, anyone?&nbsp; Is there to remove the duplicate entries after using the expression above?</P></BODY></HTML> Tue, 27 May 2014 16:33:25 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626263#M543074 marsmike 2014-05-27T16:33:25Z Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626264#M543075 <HTML><HEAD></HEAD><BODY><P>this?</P><P><IMG alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/59659_1.png" style="width: auto; height: auto;" /></P></BODY></HTML> Tue, 27 May 2014 16:44:44 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626264#M543075 maxgro 2014-05-27T16:44:44Z Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626265#M543076 <HTML><HEAD></HEAD><BODY><P>Awesome!</P><P></P><P>Is the QVW updated?</P></BODY></HTML> Tue, 27 May 2014 16:51:47 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626265#M543076 marsmike 2014-05-27T16:51:47Z Re: Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626266#M543077 <HTML><HEAD></HEAD><BODY><P>yes now</P></BODY></HTML> Tue, 27 May 2014 18:47:34 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626266#M543077 maxgro 2014-05-27T18:47:34Z Re: Filter records in a table chart https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626267#M543078 <HTML><HEAD></HEAD><BODY><P>Massimo, thank you very much, this is great!</P><P></P><P>You are THE MAN.</P></BODY></HTML> Wed, 28 May 2014 14:45:48 GMT https://community.qlik.com/t5/QlikView/Filter-records-in-a-table-chart/m-p/626267#M543078 marsmike 2014-05-28T14:45:48Z