topic Latest dimension record in plain table in QlikView https://community.qlik.com/t5/QlikView/Latest-dimension-record-in-plain-table/m-p/602679#M546544 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need to show a table with just dimension values. Therefore I use a plain table with just dimensions, no expressions.</P><P></P><P>I wonder if it's possible to customizie the plain table thus, that just the latest VERSION for each STATUS is shown.</P><P></P><P>I know that this could handled by just loading thus records, but unfortunately they are needed othwerise.</P><P></P><P>Example attached.</P><P></P><P>Best regards</P><P>Thomas</P></BODY></HTML> Wed, 05 Mar 2014 09:58:42 GMT 2014-03-05T09:58:42Z Latest dimension record in plain table https://community.qlik.com/t5/QlikView/Latest-dimension-record-in-plain-table/m-p/602679#M546544 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need to show a table with just dimension values. Therefore I use a plain table with just dimensions, no expressions.</P><P></P><P>I wonder if it's possible to customizie the plain table thus, that just the latest VERSION for each STATUS is shown.</P><P></P><P>I know that this could handled by just loading thus records, but unfortunately they are needed othwerise.</P><P></P><P>Example attached.</P><P></P><P>Best regards</P><P>Thomas</P></BODY></HTML> Wed, 05 Mar 2014 09:58:42 GMT https://community.qlik.com/t5/QlikView/Latest-dimension-record-in-plain-table/m-p/602679#M546544 2014-03-05T09:58:42Z Re: Latest dimension record in plain table https://community.qlik.com/t5/QlikView/Latest-dimension-record-in-plain-table/m-p/602680#M546545 <HTML><HEAD></HEAD><BODY><P>Try using calculated dimension for Version and then put in the logic to determine the latest one.</P></BODY></HTML> Wed, 05 Mar 2014 10:01:30 GMT https://community.qlik.com/t5/QlikView/Latest-dimension-record-in-plain-table/m-p/602680#M546545 sujeetsingh 2014-03-05T10:01:30Z Re: Latest dimension record in plain table https://community.qlik.com/t5/QlikView/Latest-dimension-record-in-plain-table/m-p/602681#M546546 <HTML><HEAD></HEAD><BODY><P>Where you dimension is version, change it to a calculated dimension and use:</P><P>=aggr(maxstring(VERSION),TPLNR,DOKAR,DOSTX,STATUS)</P><P></P><P>Your fixed file is also attached.</P></BODY></HTML> Wed, 05 Mar 2014 15:59:30 GMT https://community.qlik.com/t5/QlikView/Latest-dimension-record-in-plain-table/m-p/602681#M546546 Nicole-Smith 2014-03-05T15:59:30Z