topic Sorting of Table is not working properly... in QlikView https://community.qlik.com/t5/QlikView/Sorting-of-Table-is-not-working-properly/m-p/434715#M569219 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a straight table which has City name as dimmenssion and some expressions( one of which is Quarter1 Net Sales),</P><P>Now I have an list box which displays (5,10,15, All records)......If I select 5 from this list box then there is a varriable which will return the value as 5</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If I select 10 from this list box then there is a varriable which will return the value as 10.. and so on.</P><P>And in dimmenssion limit I have marked Largest and in place of value I gave the above mentioned Varriable.</P><P></P><P></P><P>Now If I select 5 from list box then: I want the top 5 values in the table based on my Quarter1 Net Sales in Descending order and so on.......</P><P></P><P></P><P>I tried a lot but couldn't find any solution, Plz plz help me out</P><P></P><P></P><P></P><P></P><P>Regards</P><P>Sagar Gupta</P></BODY></HTML> Fri, 19 Oct 2012 18:21:13 GMT 2012-10-19T18:21:13Z Sorting of Table is not working properly... https://community.qlik.com/t5/QlikView/Sorting-of-Table-is-not-working-properly/m-p/434715#M569219 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a straight table which has City name as dimmenssion and some expressions( one of which is Quarter1 Net Sales),</P><P>Now I have an list box which displays (5,10,15, All records)......If I select 5 from this list box then there is a varriable which will return the value as 5</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If I select 10 from this list box then there is a varriable which will return the value as 10.. and so on.</P><P>And in dimmenssion limit I have marked Largest and in place of value I gave the above mentioned Varriable.</P><P></P><P></P><P>Now If I select 5 from list box then: I want the top 5 values in the table based on my Quarter1 Net Sales in Descending order and so on.......</P><P></P><P></P><P>I tried a lot but couldn't find any solution, Plz plz help me out</P><P></P><P></P><P></P><P></P><P>Regards</P><P>Sagar Gupta</P></BODY></HTML> Fri, 19 Oct 2012 18:21:13 GMT https://community.qlik.com/t5/QlikView/Sorting-of-Table-is-not-working-properly/m-p/434715#M569219 2012-10-19T18:21:13Z Re: Sorting of Table is not working properly... https://community.qlik.com/t5/QlikView/Sorting-of-Table-is-not-working-properly/m-p/434716#M569220 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp; I think attached file helps you.</P></BODY></HTML> Fri, 19 Oct 2012 19:43:16 GMT https://community.qlik.com/t5/QlikView/Sorting-of-Table-is-not-working-properly/m-p/434716#M569220 MayilVahanan 2012-10-19T19:43:16Z