topic Re: Max and Lookup in Straight Table in QlikView https://community.qlik.com/t5/QlikView/Max-and-Lookup-in-Straight-Table/m-p/428667#M1159259 <HTML><HEAD></HEAD><BODY><P>Try firstsortedvalue(SG_Status, -SD_ID)</P></BODY></HTML> Wed, 16 Jan 2013 20:24:52 GMT danielrozental 2013-01-16T20:24:52Z Max and Lookup in Straight Table https://community.qlik.com/t5/QlikView/Max-and-Lookup-in-Straight-Table/m-p/428666#M1159258 <HTML><HEAD></HEAD><BODY><P>Can someone help me return the correct SG_Status based on the max(SG_ID)?&nbsp; The answer in the form of a straight table would be as follows, but I don't know how to solve for it. As you can from my file see I only return nulls with the exception of the first row</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">Report_ID<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>max(SG_ID)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>SG_Status</STRONG></SPAN></TH></TR><TR><TD>1000</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1001</TD><TD>2</TD><TD>2</TD></TR><TR><TD>1002</TD><TD>3</TD><TD>3</TD></TR><TR><TD>1004</TD><TD>4</TD><TD><P>2</P></TD></TR></TBODY></TABLE><P></P><P>Thanks</P></BODY></HTML> Wed, 16 Jan 2013 20:23:36 GMT https://community.qlik.com/t5/QlikView/Max-and-Lookup-in-Straight-Table/m-p/428666#M1159258 2013-01-16T20:23:36Z Re: Max and Lookup in Straight Table https://community.qlik.com/t5/QlikView/Max-and-Lookup-in-Straight-Table/m-p/428667#M1159259 <HTML><HEAD></HEAD><BODY><P>Try firstsortedvalue(SG_Status, -SD_ID)</P></BODY></HTML> Wed, 16 Jan 2013 20:24:52 GMT https://community.qlik.com/t5/QlikView/Max-and-Lookup-in-Straight-Table/m-p/428667#M1159259 danielrozental 2013-01-16T20:24:52Z Re: Max and Lookup in Straight Table https://community.qlik.com/t5/QlikView/Max-and-Lookup-in-Straight-Table/m-p/428668#M1159260 <HTML><HEAD></HEAD><BODY><P>Thanks Dan, you were right even though my model above was wrong. I wish I could give you double points for that!</P></BODY></HTML> Wed, 16 Jan 2013 20:34:52 GMT https://community.qlik.com/t5/QlikView/Max-and-Lookup-in-Straight-Table/m-p/428668#M1159260 2013-01-16T20:34:52Z