topic How to get latest record from the table? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-latest-record-from-the-table/m-p/54856#M774575 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have data set like below,</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 216px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none; background-color: whitesmoke;" width="36"><STRONG style="color: #363636; font-family: Calibri;">Route</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #363636; background-color: whitesmoke;" width="43"><STRONG style="color: #363636; font-family: Calibri;">ID</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #363636; background-color: whitesmoke;" width="137"><STRONG style="color: #363636; font-family: Calibri;">Status</STRONG></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">1</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">1</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">2</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">2</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">3</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">3</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">Change Required</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">18</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">3</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>Can you please help me with the expression where in chart it will show the latest record irrespective of selection on Route.</P><P></P><P>This is default view -</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 331px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid silver; border-image: none; background-color: whitesmoke;" width="64"><STRONG style="color: #363636; font-family: Calibri;">Route</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; background-color: whitesmoke;" width="54"><STRONG style="color: #363636; font-family: Calibri;">ID</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; background-color: whitesmoke;" width="213"><STRONG style="color: #363636; font-family: Calibri;">Status</STRONG></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: yellow;" width="64"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="54"><SPAN style="color: #363636; font-family: Calibri;">28428</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="213"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: yellow;" width="64"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="54"><SPAN style="color: #363636; font-family: Calibri;">240077</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="213"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: yellow;" width="64"><SPAN style="color: #363636; font-family: Calibri;">18</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="54"><SPAN style="color: #363636; font-family: Calibri;">240127</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="213"><P><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></P><P><SPAN style="color: #363636; font-family: Calibri;"><BR /></SPAN></P><P></P></TD></TR></TBODY></TABLE><P></P><P>Also if i select route = 6 then it should allow to show below output. If i choose 12 only Route = 12 records should be displayed.</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="331"><TBODY><TR><TD height="20" style="border: 0.5pt solid silver; border-image: none; background-color: whitesmoke;" width="64"><STRONG style="color: #363636; font-family: Calibri;">Route</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; background-color: whitesmoke;" width="54"><STRONG style="color: #363636; font-family: Calibri;">ID</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; background-color: whitesmoke;" width="213"><STRONG style="color: #363636; font-family: Calibri;">Status</STRONG></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="54"><SPAN style="color: #363636; font-family: Calibri;">28428</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="213"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="54"><SPAN style="color: #363636; font-family: Calibri;">240077</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="213"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="54"><SPAN style="color: #363636; font-family: Calibri;">240127</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="213"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR></TBODY></TABLE><P></P><P>Can any one help me in this regard?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT ashishbhuyekar 2020-11-25T16:16:04Z How to get latest record from the table? https://community.qlik.com/t5/QlikView/How-to-get-latest-record-from-the-table/m-p/54856#M774575 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have data set like below,</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 216px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none; background-color: whitesmoke;" width="36"><STRONG style="color: #363636; font-family: Calibri;">Route</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #363636; background-color: whitesmoke;" width="43"><STRONG style="color: #363636; font-family: Calibri;">ID</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #363636; background-color: whitesmoke;" width="137"><STRONG style="color: #363636; font-family: Calibri;">Status</STRONG></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">1</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">1</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">2</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">2</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">3</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">3</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">Change Required</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 windowtext windowtext; background-color: white;" width="36"><SPAN style="color: #363636; font-family: Calibri;">18</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="43"><SPAN style="color: #363636; font-family: Calibri;">3</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 windowtext windowtext #363636; background-color: white;" width="137"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>Can you please help me with the expression where in chart it will show the latest record irrespective of selection on Route.</P><P></P><P>This is default view -</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 331px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid silver; border-image: none; background-color: whitesmoke;" width="64"><STRONG style="color: #363636; font-family: Calibri;">Route</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; background-color: whitesmoke;" width="54"><STRONG style="color: #363636; font-family: Calibri;">ID</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; background-color: whitesmoke;" width="213"><STRONG style="color: #363636; font-family: Calibri;">Status</STRONG></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: yellow;" width="64"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="54"><SPAN style="color: #363636; font-family: Calibri;">28428</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="213"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: yellow;" width="64"><SPAN style="color: #363636; font-family: Calibri;">12</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="54"><SPAN style="color: #363636; font-family: Calibri;">240077</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="213"><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: yellow;" width="64"><SPAN style="color: #363636; font-family: Calibri;">18</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="54"><SPAN style="color: #363636; font-family: Calibri;">240127</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: yellow;" width="213"><P><SPAN style="color: #363636; font-family: Calibri;">New Requiremnt</SPAN></P><P><SPAN style="color: #363636; font-family: Calibri;"><BR /></SPAN></P><P></P></TD></TR></TBODY></TABLE><P></P><P>Also if i select route = 6 then it should allow to show below output. If i choose 12 only Route = 12 records should be displayed.</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="331"><TBODY><TR><TD height="20" style="border: 0.5pt solid silver; border-image: none; background-color: whitesmoke;" width="64"><STRONG style="color: #363636; font-family: Calibri;">Route</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; background-color: whitesmoke;" width="54"><STRONG style="color: #363636; font-family: Calibri;">ID</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: silver silver silver #363636; background-color: whitesmoke;" width="213"><STRONG style="color: #363636; font-family: Calibri;">Status</STRONG></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="54"><SPAN style="color: #363636; font-family: Calibri;">28428</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="213"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="54"><SPAN style="color: #363636; font-family: Calibri;">240077</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="213"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #363636 silver silver; background-color: white;" width="64"><SPAN style="color: #363636; font-family: Calibri;">6</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="54"><SPAN style="color: #363636; font-family: Calibri;">240127</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #363636 silver silver #363636; background-color: white;" width="213"><SPAN style="color: #363636; font-family: Calibri;">Available</SPAN></TD></TR></TBODY></TABLE><P></P><P>Can any one help me in this regard?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-record-from-the-table/m-p/54856#M774575 ashishbhuyekar 2020-11-25T16:16:04Z Re: How to get latest record from the table? https://community.qlik.com/t5/QlikView/How-to-get-latest-record-from-the-table/m-p/54857#M774576 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P>Dimension</P><P><STRONG>ID</STRONG></P><P></P><P>Expressions</P><P><STRONG>Max(Route)</STRONG></P><P><STRONG>FirstSortedValue(Status, -Route)</STRONG></P></BODY></HTML> Fri, 18 May 2018 10:38:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-latest-record-from-the-table/m-p/54857#M774576 sunny_talwar 2018-05-18T10:38:41Z