topic Re: FirstSortedValue and Count in QlikView https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051839#M466420 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">only</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=count(OrderNo)=Max(TOtal aggr(count(OrderNo),Date))"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">) </SPAN> in a TextBox gives you exaktly the 15/01/2016</P></BODY></HTML> Mon, 08 Feb 2016 15:09:53 GMT 2016-02-08T15:09:53Z FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051834#M466415 <HTML><HEAD></HEAD><BODY><P>Good day all</P><P></P><P>I am stuck!</P><P></P><P>What I wish to achieve is to return the date which is associated to the most number of orders for a day. Is firstsortedvalue the correct way to go? I have attached my app as well as a screenshot which adds more detail to my question:</P><P></P><P>Many thanks</P><P>Scott<IMG __jive_id="113584" alt="FSVCOUNT.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113584_FSVCOUNT.png" style="width: 620px; height: 274px;" /></P></BODY></HTML> Thu, 04 Feb 2016 15:09:32 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051834#M466415 2016-02-04T15:09:32Z Re: FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051835#M466416 <HTML><HEAD></HEAD><BODY><P>Do you really want the date or just order the date by the Count?</P></BODY></HTML> Mon, 08 Feb 2016 14:39:04 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051835#M466416 2016-02-08T14:39:04Z Re: FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051836#M466417 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>=FirstSortedValue(Date,-Aggr(Count(OrderNo),Date))</P></BODY></HTML> Mon, 08 Feb 2016 14:55:18 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051836#M466417 jolivares 2016-02-08T14:55:18Z Re: FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051837#M466418 <HTML><HEAD></HEAD><BODY><P>For the second part of the question, try this -&gt; <STRONG>=FirstSortedValue(Date,-(Aggr(Count(OrderNo),Date)* 100000+Date))</STRONG></P></BODY></HTML> Mon, 08 Feb 2016 14:58:55 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051837#M466418 sunny_talwar 2016-02-08T14:58:55Z Re: FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051838#M466419 <HTML><HEAD></HEAD><BODY><P>Part 2: Add a small value depending on date to distinguish between same Count:</P><P></P><P>=FirstSortedValue(Date,-Aggr(Count(OrderNo)<STRONG>+Date/1E6</STRONG>,Date))</P></BODY></HTML> Mon, 08 Feb 2016 15:02:06 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051838#M466419 swuehl 2016-02-08T15:02:06Z Re: FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051839#M466420 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">only</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=count(OrderNo)=Max(TOtal aggr(count(OrderNo),Date))"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">) </SPAN> in a TextBox gives you exaktly the 15/01/2016</P></BODY></HTML> Mon, 08 Feb 2016 15:09:53 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051839#M466420 2016-02-08T15:09:53Z Re: FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051840#M466421 <HTML><HEAD></HEAD><BODY><P>Does not seem to work for some reason when I copied this expression</P></BODY></HTML> Tue, 09 Feb 2016 10:00:17 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051840#M466421 2016-02-09T10:00:17Z Re: FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051841#M466422 <HTML><HEAD></HEAD><BODY><P>I require the date.</P></BODY></HTML> Tue, 09 Feb 2016 10:00:37 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051841#M466422 2016-02-09T10:00:37Z Re: FirstSortedValue and Count https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051842#M466423 <HTML><HEAD></HEAD><BODY><P>my qvw:</P></BODY></HTML> Tue, 09 Feb 2016 10:59:11 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-and-Count/m-p/1051842#M466423 2016-02-09T10:59:11Z