topic Show certain string in field in QlikView https://community.qlik.com/t5/QlikView/Show-certain-string-in-field/m-p/191688#M53673 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>plz find attached qvw file.</P><P>i hope it helps.</P><P></P><P>Regards,</P><P>Chandra</P></BODY></HTML> Thu, 31 Mar 2011 09:44:10 GMT 2011-03-31T09:44:10Z Show certain string in field https://community.qlik.com/t5/QlikView/Show-certain-string-in-field/m-p/191686#M53671 <HTML><HEAD></HEAD><BODY><DIV class="ForumPostBody" sizcache="10" sizset="0"><P>Hi All,<BR /><BR />I have this set of data</P><TABLE border="0" cellpadding="0" cellspacing="0" sizcache="10" sizset="0" style="width: 520pt; border-collapse: collapse;" width="693"><TBODY sizcache="10" sizset="0"><TR sizcache="10" sizset="0" style="height: 12.75pt;"><TD class="xl63" height="17" style="background-color: whitesmoke; width: 50pt; height: 12.75pt; border: gainsboro 0.5pt solid;" width="66"><STRONG>Claimant Type</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 57pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="76"><STRONG>Claim Number</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 38pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="50"><STRONG>Ver No</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="71"><STRONG>Payment Reserves</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="71"><STRONG>Recovery Reserves</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="70"><STRONG>Payments</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 60pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="80"><STRONG>RI Recoveries</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="71"><STRONG>Non RI Recoveries</STRONG></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="71"></TD><TD class="xl63" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 50pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="67"><STRONG></STRONG></TD></TR><TR class="even" sizcache="10" sizset="1" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">AD</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">1</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">925.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR sizcache="10" sizset="2" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">AD</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">2</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">925.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR class="even" sizcache="10" sizset="3" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">AD</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">3</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">925.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR sizcache="10" sizset="4" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">PI</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">1</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">4585.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR class="even" sizcache="10" sizset="5" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">PI</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">2</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">4585.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR sizcache="10" sizset="6" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">PI</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">3</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">4585.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR class="even" sizcache="10" sizset="7" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">TP</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">1</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">1000.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR sizcache="10" sizset="8" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">TP</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">2</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">1000.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR class="even" sizcache="10" sizset="9" style="height: 12.75pt;"><TD class="xl64" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">TP</TD><TD class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">3</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">1000.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl64" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR></TBODY></TABLE><P></P><P>I wish to return the maximum Ver No and then the corresponding data with that row ( See Below ). I have used the MAX function in an expression to select the maximum Ver no. What expression can i use to return the string which corresponds with the rest of the data on the Max Ver No field?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" sizcache="10" sizset="10" style="width: 520pt; border-collapse: collapse;" width="693"><COLGROUP><COL style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413; mso-outline-parent: collapsed;" width="66" /><COL style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779; mso-outline-parent: collapsed;" width="76" /><COL style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828; mso-outline-parent: collapsed;" width="50" /><COL style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596; mso-outline-parent: collapsed;" width="71" /><COL style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596; mso-outline-parent: collapsed;" width="71" /><COL style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560; mso-outline-parent: collapsed;" width="70" /><COL style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925; mso-outline-parent: collapsed;" width="80" /><COL style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596; mso-outline-parent: collapsed;" width="71" /><COL style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596; mso-outline-parent: collapsed;" width="71" /><COL style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450; mso-outline-parent: collapsed;" width="67" /></COLGROUP><TBODY sizcache="10" sizset="10"><TR sizcache="10" sizset="10" style="height: 12.75pt;"><TD class="xl65" height="17" style="background-color: whitesmoke; width: 50pt; height: 12.75pt; border: gainsboro 0.5pt solid;" width="66"><STRONG>Claimant Type</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 57pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="76"><STRONG>Claim Number</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 38pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="50"><STRONG>Ver No</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="71"><STRONG>Payment Reserves</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="71"><STRONG>Recovery Reserves</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="70"><STRONG>Payments</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 60pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="80"><STRONG>RI Recoveries</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="71"><STRONG>Non RI Recoveries</STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 53pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="71"><STRONG></STRONG></TD><TD class="xl65" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: whitesmoke; width: 50pt; border-top: gainsboro 0.5pt solid; border-right: gainsboro 0.5pt solid;" width="67"><STRONG></STRONG></TD></TR><TR class="even" sizcache="10" sizset="11" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">TP</TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">3</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">1000.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR sizcache="10" sizset="12" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">PI</TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">3</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">4585.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR><TR class="even" sizcache="10" sizset="13" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro 0.5pt solid; background-color: white; height: 12.75pt; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">AD</TD><TD class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">RS100202</TD><TD align="right" class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">3</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">925.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl67" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;">0.00</TD><TD align="right" class="xl66" style="border-bottom: gainsboro 0.5pt solid; border-left: gainsboro; background-color: white; border-top: gainsboro; border-right: gainsboro 0.5pt solid;"></TD></TR></TBODY></TABLE><P></P><P>Thanks in Advance<BR /><BR />Regards<BR />James</P><DIV style="clear: both;"></DIV></DIV></BODY></HTML> Thu, 31 Mar 2011 09:07:45 GMT https://community.qlik.com/t5/QlikView/Show-certain-string-in-field/m-p/191686#M53671 2011-03-31T09:07:45Z Show certain string in field https://community.qlik.com/t5/QlikView/Show-certain-string-in-field/m-p/191687#M53672 <HTML><HEAD></HEAD><BODY><P>Hello James,</P><P>Check your previous posts about the same subject.</P><P>Hope that helps.</P></BODY></HTML> Thu, 31 Mar 2011 09:13:31 GMT https://community.qlik.com/t5/QlikView/Show-certain-string-in-field/m-p/191687#M53672 Miguel_Angel_Baeyens 2011-03-31T09:13:31Z Show certain string in field https://community.qlik.com/t5/QlikView/Show-certain-string-in-field/m-p/191688#M53673 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>plz find attached qvw file.</P><P>i hope it helps.</P><P></P><P>Regards,</P><P>Chandra</P></BODY></HTML> Thu, 31 Mar 2011 09:44:10 GMT https://community.qlik.com/t5/QlikView/Show-certain-string-in-field/m-p/191688#M53673 2011-03-31T09:44:10Z