topic Re: Sorting!!! in QlikView https://community.qlik.com/t5/QlikView/Sorting/m-p/561434#M1144176 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Properties -&gt; sort -&gt; Expression </P><P></P><P>In that, you give the field Name -&gt; ID, its sor according to it</P><P></P><P></P><P>Hope that helps</P></BODY></HTML> Tue, 06 Aug 2013 08:54:10 GMT MayilVahanan 2013-08-06T08:54:10Z Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561426#M1144163 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi everyone, is there any <SPAN style="font-size: 12pt;"><STRONG>expression</STRONG></SPAN> to sort the fruits according to its ID without displaying the 'ID' column?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P></P><P>For example : </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="114" style="width: 379px; border: 1px solid rgb(0, 0, 0); height: 111px;"><TBODY><TR><TH align="center" style="background-color: rgb(102, 144, 188); text-align: center;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: center;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Fruits</STRONG></SPAN></TH><TH align="center" style="background-color: rgb(102, 144, 188); text-align: center;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Number of items sold</STRONG></SPAN></TH></TR><TR><TD style="text-align: center;">1</TD><TD style="text-align: center;">Apple</TD><TD style="text-align: center;">2</TD></TR><TR><TD style="text-align: center;">2</TD><TD style="text-align: center;">Orange</TD><TD style="text-align: center;">4</TD></TR><TR><TD style="text-align: center;">3</TD><TD style="text-align: center;">Pear</TD><TD style="text-align: center;">56</TD></TR><TR><TD style="text-align: center;">4</TD><TD style="text-align: center;">Strawberry</TD><TD style="text-align: center;">7</TD></TR></TBODY></TABLE><P></P><P>BUT, i would like to sort the fruit's ID in custom order without displaying the 'ID' column shown above.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="114" style="width: 309px; border: 1px solid #000000; height: 107px;"><TBODY><TR><TH align="center" style="background-color: #6690bc; text-align: center;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Fruits</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc; text-align: center;" valign="middle"><STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">Number of items sold</STRONG><BR /></TH></TR><TR><TD style="text-align: center;"><SPAN style="text-align: center;">Pear</SPAN></TD><TD style="text-align: center;"><SPAN style="text-align: center;">56</SPAN></TD></TR><TR><TD style="text-align: center;"><SPAN style="text-align: center;">Strawberry</SPAN></TD><TD style="text-align: center;"><SPAN style="text-align: center;">7</SPAN></TD></TR><TR><TD style="text-align: center;"><SPAN style="text-align: center;">Orange</SPAN></TD><TD style="text-align: center;">4</TD></TR><TR><TD style="text-align: center;"><SPAN style="text-align: center;">Apple</SPAN></TD><TD style="text-align: center;"><SPAN style="text-align: center;">2</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 06 Aug 2013 07:36:16 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561426#M1144163 2013-08-06T07:36:16Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561427#M1144164 <HTML><HEAD></HEAD><BODY><P>sum(TEU)</P></BODY></HTML> Tue, 06 Aug 2013 07:43:08 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561427#M1144164 n1ef5ng1 2013-08-06T07:43:08Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561428#M1144166 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Hi,I would like to sort the fruits's ID in custom order. And, i didnt mention TEU in my question. I think you replied the wrong question.</SPAN></P></BODY></HTML> Tue, 06 Aug 2013 07:48:51 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561428#M1144166 2013-08-06T07:48:51Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561429#M1144168 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Go to Properties-&gt;Sort</P><P>Select the Dimension check the Expression and enter ID As shown in the figure</P><P>This will Sort by ID</P><P></P><P>Regards,</P><P>Priya</P></BODY></HTML> Tue, 06 Aug 2013 07:53:22 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561429#M1144168 priyav24 2013-08-06T07:53:22Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561430#M1144169 <HTML><HEAD></HEAD><BODY><P>Hi, I would like to do a custom sort. Not just an automatic sort. Is there any way?</P></BODY></HTML> Tue, 06 Aug 2013 07:58:13 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561430#M1144169 2013-08-06T07:58:13Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561431#M1144170 <HTML><HEAD></HEAD><BODY><P>in script--</P><P></P><P><STRONG>load Fruit ,item</STRONG></P><P><STRONG>resident table</STRONG></P><P><STRONG>order by fruit asc;</STRONG></P></BODY></HTML> Tue, 06 Aug 2013 08:02:32 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561431#M1144170 2013-08-06T08:02:32Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561432#M1144172 <HTML><HEAD></HEAD><BODY><P>In this Expression you can customize by giving the suitable expression..</P><P>For eg:</P><P>Here you want sort by id,So we have given by id...</P><P>Like this you can do according to your requirement</P></BODY></HTML> Tue, 06 Aug 2013 08:03:48 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561432#M1144172 priyav24 2013-08-06T08:03:48Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561433#M1144174 <HTML><HEAD></HEAD><BODY><P>Take all the three dimensions in the table and sort the table on ID, then hide the ID column in the presentation tab.</P></BODY></HTML> Tue, 06 Aug 2013 08:13:26 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561433#M1144174 tresB 2013-08-06T08:13:26Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561434#M1144176 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Properties -&gt; sort -&gt; Expression </P><P></P><P>In that, you give the field Name -&gt; ID, its sor according to it</P><P></P><P></P><P>Hope that helps</P></BODY></HTML> Tue, 06 Aug 2013 08:54:10 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561434#M1144176 MayilVahanan 2013-08-06T08:54:10Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561435#M1144178 <HTML><HEAD></HEAD><BODY><P>Yes it is.</P><P>PFA </P></BODY></HTML> Tue, 06 Aug 2013 09:06:31 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561435#M1144178 priyav24 2013-08-06T09:06:31Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561436#M1144179 <HTML><HEAD></HEAD><BODY><P>Hii </P><P>Go to </P><P>Chart Properties -&gt; Sort -&gt; Expression</P><P></P><P>then write : =num(ID)</P><P></P><P>Make it Ascending - If you required to sort 1 ,2,3,4,&nbsp; Sequence...</P><P></P><P>For Your Reference I attch Image</P></BODY></HTML> Tue, 06 Aug 2013 09:32:53 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561436#M1144179 2013-08-06T09:32:53Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561437#M1144180 <HTML><HEAD></HEAD><BODY><P>see the attched one</P></BODY></HTML> Tue, 06 Aug 2013 09:34:32 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561437#M1144180 Kushal_Chawda 2013-08-06T09:34:32Z Re: Sorting!!! https://community.qlik.com/t5/QlikView/Sorting/m-p/561438#M1144181 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>goto the properties--&gt; sort</P><P>for fruits&nbsp; write expression as&nbsp;&nbsp;&nbsp; </P><P>wildmatch('Fruits ,'pears','strawberry','orange',apple') and select the ascending order for the expression.</P></BODY></HTML> Tue, 06 Aug 2013 13:36:01 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/561438#M1144181 shree909 2013-08-06T13:36:01Z