topic Re: how do i sort based on selected values in QlikView https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096929#M364338 <HTML><HEAD></HEAD><BODY><P>Not really sure if I understand what you want to achieve.</P><P></P><P>I think you probably need set analysis in all your expressions to ignore the selection in your dimension field, as far as I understood, you don't want to limit the dimension values based on your selection.</P><P></P><P>Then you need to create a sort expression that puts the selected value first in order.</P><P></P><P>Maybe something like attached?</P></BODY></HTML> Tue, 23 Feb 2016 23:38:15 GMT swuehl 2016-02-23T23:38:15Z how do i sort based on selected values https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096928#M364337 <HTML><HEAD></HEAD><BODY><P>I have a straight table , with multiple dimensions and expressions , I need to sort based on a dimension value selected in the chart ...</P><P>so what ever value is selected that has to be appeared on the top of the chart</P><P></P><P></P><P>Thanks</P></BODY></HTML> Tue, 23 Feb 2016 22:56:34 GMT https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096928#M364337 Anonymous 2016-02-23T22:56:34Z Re: how do i sort based on selected values https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096929#M364338 <HTML><HEAD></HEAD><BODY><P>Not really sure if I understand what you want to achieve.</P><P></P><P>I think you probably need set analysis in all your expressions to ignore the selection in your dimension field, as far as I understood, you don't want to limit the dimension values based on your selection.</P><P></P><P>Then you need to create a sort expression that puts the selected value first in order.</P><P></P><P>Maybe something like attached?</P></BODY></HTML> Tue, 23 Feb 2016 23:38:15 GMT https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096929#M364338 swuehl 2016-02-23T23:38:15Z Re: how do i sort based on selected values https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096930#M364339 <HTML><HEAD></HEAD><BODY><P>Ok , I ignored all my expression with dimensions values but that will disable my filters correct?</P><P>Attached my application .. I basically want the sort order to be by SERVICE API , what ever value is slected should be top of the chart , first records should be the values for selected service api</P></BODY></HTML> Tue, 23 Feb 2016 23:51:34 GMT https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096930#M364339 Anonymous 2016-02-23T23:51:34Z Re: how do i sort based on selected values https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096931#M364340 <HTML><HEAD></HEAD><BODY><P>You only need to clear selections in the dimension field you want to sort by selection.</P><P></P><P>Maybe like attached (see sort tab).</P><P></P><P>edit: Sample QVW deleted on request</P></BODY></HTML> Tue, 23 Feb 2016 23:57:43 GMT https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096931#M364340 swuehl 2016-02-23T23:57:43Z Re: how do i sort based on selected values https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096932#M364341 <HTML><HEAD></HEAD><BODY><P>Thank you !!</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Field</SPAN><SPAN style="font-size: 8pt;"> = </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">GetFieldSelections</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Field</SPAN><SPAN style="font-size: 8pt;">),-1) , worked!!</SPAN></P><P></P><P>Can you please delete the application from your post.</P></BODY></HTML> Wed, 24 Feb 2016 01:00:46 GMT https://community.qlik.com/t5/QlikView/how-do-i-sort-based-on-selected-values/m-p/1096932#M364341 Anonymous 2016-02-24T01:00:46Z