topic Re: First Sorted Value in QlikView https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/672089#M244099 <HTML><HEAD></HEAD><BODY><P>Works like a charm, thanks so much for the help!</P><P></P><P>Matt</P></BODY></HTML> Fri, 27 Jun 2014 22:50:57 GMT 2014-06-27T22:50:57Z First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/672087#M244097 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm trying to use the first sorted value function to return the overall winner of a test we're running. The table below shows the data I'm working with:</P><P><IMG alt="Screen Shot 2014-06-27 at 17.28.22.png" class="jive-image" height="140" src="/legacyfs/online/61375_Screen Shot 2014-06-27 at 17.28.22.png" style="width: 368px; height: 140.0774193548387px;" width="368" /></P><P>The winner of this test has the highest Prejoin&gt;Join ratio, which in this case is Theme 3200. I'd like to return the value 3200 in every row in the column 'Overall Winner'. I'm using the following expression without success:</P><P><SPAN class="s1">=</SPAN>FirstSortedValue<SPAN class="s1">(</SPAN><SPAN class="s2">Themes</SPAN><SPAN class="s1">, -</SPAN>Aggr<SPAN class="s1">(</SPAN>sum<SPAN class="s1">(</SPAN><SPAN class="s3"><STRONG><EM>vCTR</EM></STRONG></SPAN><SPAN class="s1">),</SPAN><SPAN class="s2">Themes</SPAN><SPAN class="s1">)) </SPAN></P><P><SPAN class="s1"><BR /></SPAN></P><P><SPAN class="s1">vCTR is simply a variable storing the quotient of Join/Prejoin. If anyone has an idea on how to solve this that would be great. Sample data attached.</SPAN></P><P><SPAN class="s1"><BR /></SPAN></P><P><SPAN class="s1">Thanks.</SPAN></P><P><SPAN class="s1"><BR /></SPAN></P><P><SPAN class="s1">Matt<BR /></SPAN></P></BODY></HTML> Fri, 27 Jun 2014 21:48:41 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/672087#M244097 2014-06-27T21:48:41Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/672088#M244098 <HTML><HEAD></HEAD><BODY><P>This should do the trick:</P><P>only({&lt;Themes={'=rank(sum(CT)/sum(C),0,1)=1'}&gt;}total Themes)</P></BODY></HTML> Fri, 27 Jun 2014 22:13:00 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/672088#M244098 Nicole-Smith 2014-06-27T22:13:00Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/672089#M244099 <HTML><HEAD></HEAD><BODY><P>Works like a charm, thanks so much for the help!</P><P></P><P>Matt</P></BODY></HTML> Fri, 27 Jun 2014 22:50:57 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/672089#M244099 2014-06-27T22:50:57Z