topic max clm_no in QlikView

topic max clm_no in QlikView https://community.qlik.com/t5/QlikView/max-clm-no/m-p/1175094#M899578 <HTML><HEAD></HEAD><BODY><P>this is my table </P><P>        </P><TABLE border="0" cellspacing="0"><TBODY><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Value</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">status</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Max_date</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">clm_no</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Current_date</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Differnce</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">clm_num</STRONG></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">04-Jan-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506-1</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">197</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30-Nov-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">232</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">24-Dec-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10329647</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">208</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">06-Dec-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10326507</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">226</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">26-Jan-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506-2</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">175</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">0.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">01-May-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS16-10349544</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">79</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">31-May-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS16-10349544-1</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">49</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#F5F5F5" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">1.250</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">Outlier</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">31-May-2016</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">RC-HS16-10349544-1</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">18/07/2016</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">49</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">-</STRONG></TD></TR></TBODY></TABLE><P></P><P>in this i want highest max date along with its clm_no but i dont want its supplementary clm no</P><P></P><P>above table giving me right but it showing me with supplementary clm_no that i dont wnt so it should give </P><P>        </P><TABLE border="0" cellspacing="0"><TBODY><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Value</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">status</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Max_date</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">clm_no</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Current_date</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Differnce</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">clm_num</STRONG></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">04-Jan-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506-1</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">197</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30-Nov-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">232</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">24-Dec-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10329647</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">208</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">06-Dec-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10326507</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">226</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">26-Jan-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506-2</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">175</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">0.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">01-May-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS16-10349544</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">79</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">31-May-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS16-10349544-1</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">49</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#F5F5F5" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">1.250</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">Outlier</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">01-May-2016</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">RC-HS16-10349544</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">18/07/2016</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">49</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">-</STRONG></TD></TR></TBODY></TABLE><P></P><P>so can any on help me in this </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT sagarrahul 2020-11-25T16:16:04Z max clm_no https://community.qlik.com/t5/QlikView/max-clm-no/m-p/1175094#M899578 <HTML><HEAD></HEAD><BODY><P>this is my table </P><P>        </P><TABLE border="0" cellspacing="0"><TBODY><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Value</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">status</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Max_date</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">clm_no</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Current_date</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Differnce</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">clm_num</STRONG></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">04-Jan-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506-1</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">197</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30-Nov-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">232</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">24-Dec-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10329647</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">208</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">06-Dec-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10326507</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">226</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">26-Jan-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506-2</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">175</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">0.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">01-May-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS16-10349544</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">79</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">31-May-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS16-10349544-1</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">49</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#F5F5F5" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">1.250</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">Outlier</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">31-May-2016</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">RC-HS16-10349544-1</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">18/07/2016</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">49</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">-</STRONG></TD></TR></TBODY></TABLE><P></P><P>in this i want highest max date along with its clm_no but i dont want its supplementary clm no</P><P></P><P>above table giving me right but it showing me with supplementary clm_no that i dont wnt so it should give </P><P>        </P><TABLE border="0" cellspacing="0"><TBODY><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Value</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">status</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Max_date</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">clm_no</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Current_date</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">Differnce</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">clm_num</STRONG></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">04-Jan-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506-1</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">197</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">30-Nov-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">232</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">24-Dec-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10329647</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">208</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">1.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">06-Dec-2015</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10326507</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">226</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">26-Jan-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS15-10325506-2</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">175</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">0.000</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">01-May-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS16-10349544</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">79</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#FFFFFF" height="20" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">Not Outlier</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">31-May-2016</SPAN></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">RC-HS16-10349544-1</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">18/07/2016</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">49</SPAN></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><SPAN style="color: #333333; font-family: Tahoma; font-size: 8pt;">-</SPAN></TD></TR><TR><TD bgcolor="#F5F5F5" height="20" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">1.250</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">Outlier</STRONG></TD><TD bgcolor="#FFFFFF" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">01-May-2016</STRONG></TD><TD bgcolor="#FFFF00" style="border: 1px solid #dcdcdc;"><STRONG style="color: #333333; font-size: 8pt; font-family: Tahoma;">RC-HS16-10349544</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">18/07/2016</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">49</STRONG></TD><TD bgcolor="#F5F5F5" style="border: 1px solid #dcdcdc;"><STRONG style="color: #000000; font-size: 8pt; font-family: Tahoma;">-</STRONG></TD></TR></TBODY></TABLE><P></P><P>so can any on help me in this </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/max-clm-no/m-p/1175094#M899578 sagarrahul 2020-11-25T16:16:04Z