topic FirstSortedValue in a Straight Table in QlikView https://community.qlik.com/t5/QlikView/FirstSortedValue-in-a-Straight-Table/m-p/341364#M572928 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to get the First line of data in the following Table</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Claim Number</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Claim Done Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sum([Claimant Reserve Payment])</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>FirstSortedValue(Sum([Claimant Reserve Payment]), [Claim Done Date])</STRONG></SPAN></TH></TR><TR><TD>AE000827</TD><TD>03/07/2012</TD><TD><P>9108.2</P></TD><TD>-</TD></TR><TR><TD><P>AE000827</P></TD><TD>04/07/2012</TD><TD>16358.2</TD><TD>-</TD></TR><TR><TD>AE000827</TD><TD>05/07/2012</TD><TD>10042.2</TD><TD>-</TD></TR><TR><TD>AE000827</TD><TD>06/07/2012</TD><TD>10042.2</TD><TD>-</TD></TR><TR><TD>AE000827</TD><TD>09/07/2012</TD><TD>10042.2</TD><TD>-</TD></TR></TBODY></TABLE><P></P><P>What I was hoping for was the table just to show the first line so I know what the reserve was on the earliest date.&nbsp; As you can see my expression using firstsortedvalue is just returning nulls</P><P></P><P>Can anyone help Please</P><P></P><P>Regards</P><P></P><P>Matt</P></BODY></HTML> Mon, 09 Jul 2012 15:07:54 GMT 2012-07-09T15:07:54Z FirstSortedValue in a Straight Table https://community.qlik.com/t5/QlikView/FirstSortedValue-in-a-Straight-Table/m-p/341364#M572928 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to get the First line of data in the following Table</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Claim Number</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Claim Done Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sum([Claimant Reserve Payment])</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>FirstSortedValue(Sum([Claimant Reserve Payment]), [Claim Done Date])</STRONG></SPAN></TH></TR><TR><TD>AE000827</TD><TD>03/07/2012</TD><TD><P>9108.2</P></TD><TD>-</TD></TR><TR><TD><P>AE000827</P></TD><TD>04/07/2012</TD><TD>16358.2</TD><TD>-</TD></TR><TR><TD>AE000827</TD><TD>05/07/2012</TD><TD>10042.2</TD><TD>-</TD></TR><TR><TD>AE000827</TD><TD>06/07/2012</TD><TD>10042.2</TD><TD>-</TD></TR><TR><TD>AE000827</TD><TD>09/07/2012</TD><TD>10042.2</TD><TD>-</TD></TR></TBODY></TABLE><P></P><P>What I was hoping for was the table just to show the first line so I know what the reserve was on the earliest date.&nbsp; As you can see my expression using firstsortedvalue is just returning nulls</P><P></P><P>Can anyone help Please</P><P></P><P>Regards</P><P></P><P>Matt</P></BODY></HTML> Mon, 09 Jul 2012 15:07:54 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-in-a-Straight-Table/m-p/341364#M572928 2012-07-09T15:07:54Z Re: FirstSortedValue in a Straight Table https://community.qlik.com/t5/QlikView/FirstSortedValue-in-a-Straight-Table/m-p/341365#M572929 <HTML><HEAD></HEAD><BODY><P>If you are using QV11 use dimension limits and show first row.</P><P></P><P>If not use the following experssion for Reserve</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13418496929083441" jivemacro_uid="_13418496929083441"><P>Sum({&lt;[Claim Done Date]={"$(=min([Claim Done Date]))"}&gt;} [Claimant Reserve Payment])</P></PRE><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Mon, 09 Jul 2012 16:00:16 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-in-a-Straight-Table/m-p/341365#M572929 2012-07-09T16:00:16Z