topic Re: First Sorted Value in QlikView https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079315#M932292 <HTML><HEAD></HEAD><BODY><P>Your text box was originally set to inherited state, and your sheet was not set to the same state as the table chart. The default state shows a lot more and different selections than visible in your sheet, hence filtering your table in a different way than the records available to&nbsp; the firstsortedvalue() function.</P><P></P><P>With QV12, it now works for me.</P><P>I know that the sorted aggr() doesn't work in 11.2, but my time is up, I am out of the game.</P></BODY></HTML> Wed, 02 Mar 2016 23:25:49 GMT swuehl 2016-03-02T23:25:49Z First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079308#M932282 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to get the first sorted value in the text box , can I know why its not being shown ?</P><P>Attached my App</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079308#M932282 Anonymous 2020-11-25T16:16:04Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079309#M932283 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>=FirstSortedValue(<STRONG>DISTINCT</STRONG> Function,ServiceTimeSeries.Date)</P></BODY></HTML> Wed, 02 Mar 2016 22:18:57 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079309#M932283 swuehl 2016-03-02T22:18:57Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079310#M932284 <HTML><HEAD></HEAD><BODY><P>Seems to work for me</P></BODY></HTML> Wed, 02 Mar 2016 22:27:28 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079310#M932284 swuehl 2016-03-02T22:27:28Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079311#M932285 <HTML><HEAD></HEAD><BODY><P>Your sort weight is Date, but there are several functions with the same highest date.</P><P>You want the function the sorts first by text A-Z?</P></BODY></HTML> Wed, 02 Mar 2016 22:32:13 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079311#M932285 swuehl 2016-03-02T22:32:13Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079312#M932286 <HTML><HEAD></HEAD><BODY><P>Yes , Function sort by Date, and if multiple values sort by A-Z </P></BODY></HTML> Wed, 02 Mar 2016 22:56:20 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079312#M932286 Anonymous 2016-03-02T22:56:20Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079313#M932287 <HTML><HEAD></HEAD><BODY><P>It took some time to sort out how your chart works (and that you are using alternate states in your sheet).</P><P></P><P>You are using QV12, right?</P><P></P><P>Then maybe you can use the new sortable aggr() function.</P><P><A href="https://community.qlik.com/qlik-blogpost/4673">The sortable Aggr function is finally here!</A></P><P></P><P>See attached.</P></BODY></HTML> Wed, 02 Mar 2016 23:15:25 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079313#M932287 swuehl 2016-03-02T23:15:25Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079314#M932289 <HTML><HEAD></HEAD><BODY><P>I am actually using Qlikview 11.2 , the expression in the text box shows an error , sorry I should have told you that I have alternate states for the Tab.. but just out of curiosity can I know how it matters ?</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/116714_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /> </P></BODY></HTML> Wed, 02 Mar 2016 23:19:49 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079314#M932289 Anonymous 2016-03-02T23:19:49Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079315#M932292 <HTML><HEAD></HEAD><BODY><P>Your text box was originally set to inherited state, and your sheet was not set to the same state as the table chart. The default state shows a lot more and different selections than visible in your sheet, hence filtering your table in a different way than the records available to&nbsp; the firstsortedvalue() function.</P><P></P><P>With QV12, it now works for me.</P><P>I know that the sorted aggr() doesn't work in 11.2, but my time is up, I am out of the game.</P></BODY></HTML> Wed, 02 Mar 2016 23:25:49 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079315#M932292 swuehl 2016-03-02T23:25:49Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079316#M932295 <HTML><HEAD></HEAD><BODY><P>It will give the first value of the expression based on sorted weight ,sorted weight should be numeric...</P></BODY></HTML> Thu, 03 Mar 2016 05:36:45 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079316#M932295 prabhas277 2016-03-03T05:36:45Z Re: First Sorted Value https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079317#M932299 <HTML><HEAD></HEAD><BODY><P>How do I sort by alphabetically considering date as sort weight ? </P></BODY></HTML> Thu, 03 Mar 2016 06:55:00 GMT https://community.qlik.com/t5/QlikView/First-Sorted-Value/m-p/1079317#M932299 Anonymous 2016-03-03T06:55:00Z