topic Sort based on values in QlikView https://community.qlik.com/t5/QlikView/Sort-based-on-values/m-p/1168248#M913029 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>&nbsp; I am having following scenario.</P><P></P><P>1 . When I Click "Id" I need to sort based on "Sort" column</P><P>2. When I "Clear All" still I need to have the sort order column dimension followed by non "Id" Values</P><P></P><P>All I need is irrespective of the "Id" qlik I need to sort based on sort column followed by non "Id values.</P><P></P><P>Kindly let me know if any queries</P><P></P><P>-Jay</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Sort based on values https://community.qlik.com/t5/QlikView/Sort-based-on-values/m-p/1168248#M913029 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>&nbsp; I am having following scenario.</P><P></P><P>1 . When I Click "Id" I need to sort based on "Sort" column</P><P>2. When I "Clear All" still I need to have the sort order column dimension followed by non "Id" Values</P><P></P><P>All I need is irrespective of the "Id" qlik I need to sort based on sort column followed by non "Id values.</P><P></P><P>Kindly let me know if any queries</P><P></P><P>-Jay</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sort-based-on-values/m-p/1168248#M913029 Anonymous 2020-11-25T16:16:04Z Re: Sort based on values https://community.qlik.com/t5/QlikView/Sort-based-on-values/m-p/1168249#M913030 <HTML><HEAD></HEAD><BODY><P>Maybe using a sort expression like</P><P></P><P> If(GetSelectedCount(Id),min(Sort),Rangesum(Min({&lt;Id = {Y}&gt;}Sort),Only({&lt;Id = E({&lt;Id = {Y}&gt;}) &gt;} Ord(lower(Rules)))))</P></BODY></HTML> Mon, 30 May 2016 08:17:42 GMT https://community.qlik.com/t5/QlikView/Sort-based-on-values/m-p/1168249#M913030 swuehl 2016-05-30T08:17:42Z