topic Re: firstsortedvalue and sort by 'load order' in QlikView https://community.qlik.com/t5/QlikView/firstsortedvalue-and-sort-by-load-order/m-p/704355#M253999 <HTML><HEAD></HEAD><BODY><P>Can you show sample input and expected output.</P></BODY></HTML> Fri, 10 Oct 2014 16:49:18 GMT anbu1984 2014-10-10T16:49:18Z firstsortedvalue and sort by 'load order' https://community.qlik.com/t5/QlikView/firstsortedvalue-and-sort-by-load-order/m-p/704354#M253998 <HTML><HEAD></HEAD><BODY><P>I need a way to get the first value in a filter to be selected.&nbsp; The value will be a standard sort in asc, however, in my case the field sits in a fact table.&nbsp; The value can be any text.</P><P></P><P>The only way i can see this being done is to create a load of the field list in the script and load that in ascending order.&nbsp; Do this part at the beginning of the script snd then drop the table used.</P><P></P><P>I can then use a trigger to select the field, however, I need to do a firstsortedvalue with the sort order being the load.</P></BODY></HTML> Fri, 10 Oct 2014 15:40:26 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-and-sort-by-load-order/m-p/704354#M253998 2014-10-10T15:40:26Z Re: firstsortedvalue and sort by 'load order' https://community.qlik.com/t5/QlikView/firstsortedvalue-and-sort-by-load-order/m-p/704355#M253999 <HTML><HEAD></HEAD><BODY><P>Can you show sample input and expected output.</P></BODY></HTML> Fri, 10 Oct 2014 16:49:18 GMT https://community.qlik.com/t5/QlikView/firstsortedvalue-and-sort-by-load-order/m-p/704355#M253999 anbu1984 2014-10-10T16:49:18Z