topic Re: Get only last suborder in QlikView https://community.qlik.com/t5/QlikView/Get-only-last-suborder/m-p/890789#M310333 <HTML><HEAD></HEAD><BODY><P>Thanks Swuehl! </P></BODY></HTML> Tue, 16 Jun 2015 06:54:38 GMT 2015-06-16T06:54:38Z Get only last suborder https://community.qlik.com/t5/QlikView/Get-only-last-suborder/m-p/890787#M310331 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I have an ordertable that contains original orders (-00) and subsequent suborders (-XX), something like this:</P><P></P><P>4110400</P><P>4110401</P><P>4110402</P><P>4221100</P><P>4223300</P><P>4224400</P><P>4224401</P><P>4224402</P><P>4224403</P><P></P><P>or</P><P></P><P>41104-00</P><P>41104-01</P><P>41104-02</P><P>42211-00</P><P>42233-00</P><P>42244-00</P><P>42244-01</P><P>42244-02</P><P>42244-03</P><P></P><P>I want to render the following only loading the maximum of the suborders where exists or the orginalorder where suborderdoesn't exist, with the resulting table:</P><P></P><P>41104-02</P><P>42211-00</P><P>42233-00</P><P>42244-03</P><P></P><P>In fact lower numbered suborders are not of interest loading.</P><P></P><P>How do I go about solving this (scripting this), to render the table with only the highest order suffix ?</P><P></P><P></P><P>Thank you &amp; BR,</P><P>David</P></BODY></HTML> Mon, 15 Jun 2015 09:33:25 GMT https://community.qlik.com/t5/QlikView/Get-only-last-suborder/m-p/890787#M310331 2015-06-15T09:33:25Z Re: Get only last suborder https://community.qlik.com/t5/QlikView/Get-only-last-suborder/m-p/890788#M310332 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 12pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 12pt;"> <SPAN style="color: #800080;">FirstsortedValue</SPAN>(<SPAN style="color: #008000;">Test</SPAN>,-<SPAN style="color: #800080;">subfield</SPAN>(<SPAN style="color: #008000;">Test</SPAN>,<SPAN style="color: #0000ff;">'-'</SPAN>,<SPAN style="color: #0000ff;">2</SPAN>)) <SPAN style="; color: #0000ff;"><STRONG>as</STRONG></SPAN> <SPAN style="color: #008000;">Test</SPAN> </SPAN></P><P><SPAN style="font-size: 12pt;"> <SPAN style="color: #0000ff;"><STRONG>INLINE</STRONG></SPAN> <SPAN style="color: #008000;">[</SPAN></SPAN></P><P><SPAN style="color: #008000; font-size: 12pt;"> Test</SPAN></P><P><SPAN style="font-size: 12pt;">41104-00</SPAN></P><P><SPAN style="font-size: 12pt;">41104-01</SPAN></P><P><SPAN style="font-size: 12pt;">41104-02</SPAN></P><P><SPAN style="font-size: 12pt;">42211-00</SPAN></P><P><SPAN style="font-size: 12pt;">42233-00</SPAN></P><P><SPAN style="font-size: 12pt;">42244-00</SPAN></P><P><SPAN style="font-size: 12pt;">42244-01</SPAN></P><P><SPAN style="font-size: 12pt;">42244-02</SPAN></P><P><SPAN style="font-size: 12pt;">42244-03</SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 12pt;"><STRONG>]</STRONG></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #0000ff;"><STRONG>Group</STRONG></SPAN> <SPAN style="; color: #0000ff;"><STRONG>by</STRONG></SPAN> <SPAN style="color: #800080;">subfield</SPAN>(<SPAN style="color: #008000;">Test</SPAN>,<SPAN style="color: #0000ff;">'-'</SPAN>,<SPAN style="color: #0000ff;">1</SPAN></SPAN><SPAN style="font-size: 12pt;">)</SPAN></P><P><SPAN style="font-size: 8pt;">;</SPAN></P><P></P><P>Or in the first case, use something like this:</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG>LOAD</STRONG></SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800080; font-size: 8pt;">FirstsortedValue</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #008000; font-size: 8pt;">Test</SPAN><SPAN style="font-size: 8pt;">,-</SPAN><SPAN style="color: #800080; font-size: 8pt;">right</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #008000; font-size: 8pt;">Test</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">2</SPAN><SPAN style="font-size: 8pt;">)) </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">as</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #008000; font-size: 8pt;">Test</SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG>INLINE</STRONG></SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #008000; font-size: 8pt;">[</SPAN></P><P>4110400</P><P>4110401</P><P>4110402</P><P>4221100</P><P>4223300</P><P>4224400</P><P>4224401</P><P>4224402</P><P>4224403</P><P>]</P><P><SPAN style="color: #0000ff; font-size: 8pt;"><STRONG>Group</STRONG></SPAN><SPAN style="font-size: 8pt;"> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">by</STRONG><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800080; font-size: 8pt;">left</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #008000; font-size: 8pt;">Test</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">5</SPAN><SPAN style="font-size: 8pt;">)</SPAN></P><P><SPAN style="font-size: 8pt;">;</SPAN></P><P><SPAN style="font-size: 8pt;"> </SPAN></P></BODY></HTML> Mon, 15 Jun 2015 15:22:13 GMT https://community.qlik.com/t5/QlikView/Get-only-last-suborder/m-p/890788#M310332 swuehl 2015-06-15T15:22:13Z Re: Get only last suborder https://community.qlik.com/t5/QlikView/Get-only-last-suborder/m-p/890789#M310333 <HTML><HEAD></HEAD><BODY><P>Thanks Swuehl! </P></BODY></HTML> Tue, 16 Jun 2015 06:54:38 GMT https://community.qlik.com/t5/QlikView/Get-only-last-suborder/m-p/890789#M310333 2015-06-16T06:54:38Z