topic Re: How to Order a table in QlikView https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861230#M301430 <HTML><HEAD></HEAD><BODY><P>Hi Marco <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>which fields have you for this order by issue?</P><P></P><P>Consider to use a chart (straight table) and not a Table object: you have a Limit Dimension tab that could help you.</P><P></P><P>S.</P></BODY></HTML> Wed, 27 May 2015 12:47:11 GMT simospa 2015-05-27T12:47:11Z How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861229#M301429 <HTML><HEAD></HEAD><BODY><P>Hello i need a table with the top 10 Images loaded into an istagram account but my question is how to order the datas and to limit the results to the first 10 images?</P><P></P><P>Thanks</P><P>Marco</P></BODY></HTML> Wed, 27 May 2015 12:42:46 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861229#M301429 marco_puccetti 2015-05-27T12:42:46Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861230#M301430 <HTML><HEAD></HEAD><BODY><P>Hi Marco <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>which fields have you for this order by issue?</P><P></P><P>Consider to use a chart (straight table) and not a Table object: you have a Limit Dimension tab that could help you.</P><P></P><P>S.</P></BODY></HTML> Wed, 27 May 2015 12:47:11 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861230#M301430 simospa 2015-05-27T12:47:11Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861231#M301431 <HTML><HEAD></HEAD><BODY><P>Hi Marco,</P><P></P><P>Use the below statements:</P><P></P><P>Dimension: = <STRONG>if(aggr(rank(sum(Value)),Dim)&lt;=10,Dim)</STRONG></P><P></P><P>Expression: <STRONG>sum(Value)</STRONG></P><P></P><P></P><P>Regards,</P><P>Sridhar</P></BODY></HTML> Wed, 27 May 2015 12:56:28 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861231#M301431 2015-05-27T12:56:28Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861232#M301432 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P></P><P>Marco</P></BODY></HTML> Wed, 27 May 2015 14:29:09 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861232#M301432 marco_puccetti 2015-05-27T14:29:09Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861233#M301433 <HTML><HEAD></HEAD><BODY><P>As regard the date what have i to set in this section?</P><P></P><P></P><P><IMG alt="Dialog.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87817_Dialog.png" style="height: 324px; width: 620px;" /></P><P></P><P>Thanks</P><P>Marco</P></BODY></HTML> Thu, 28 May 2015 12:44:38 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861233#M301433 marco_puccetti 2015-05-28T12:44:38Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861234#M301434 <HTML><HEAD></HEAD><BODY><P>u can use dimension limits tab and define value as top 10 and uncheck other check boc from same tab.</P></BODY></HTML> Thu, 28 May 2015 13:04:25 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861234#M301434 buzzy996 2015-05-28T13:04:25Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861235#M301435 <HTML><HEAD></HEAD><BODY><P>To set the top 10 ordering is it correct?</P><P></P><P><IMG alt="Immagine1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87830_Immagine1.png" style="height: 443px; width: 620px;" /></P></BODY></HTML> Thu, 28 May 2015 13:45:33 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861235#M301435 marco_puccetti 2015-05-28T13:45:33Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861236#M301436 <HTML><HEAD></HEAD><BODY><P>yes dear,are u got expected out after that setting?</P></BODY></HTML> Thu, 28 May 2015 13:51:27 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861236#M301436 buzzy996 2015-05-28T13:51:27Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861237#M301437 <HTML><HEAD></HEAD><BODY><P>With this setting combined with the date sorting i get a tables sorted by date from the most recent to the less recent.</P><P></P><P>Marco</P></BODY></HTML> Thu, 28 May 2015 13:54:14 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861237#M301437 marco_puccetti 2015-05-28T13:54:14Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861238#M301438 <HTML><HEAD></HEAD><BODY><P>yes,tht will give result accordingly ur dimensions &amp; expresions,tht's not ur looking for?</P></BODY></HTML> Thu, 28 May 2015 13:57:11 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861238#M301438 buzzy996 2015-05-28T13:57:11Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861239#M301439 <HTML><HEAD></HEAD><BODY><P>Yes it is!!</P><P></P><P>Marco</P></BODY></HTML> Thu, 28 May 2015 14:39:50 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861239#M301439 marco_puccetti 2015-05-28T14:39:50Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861240#M301440 <HTML><HEAD></HEAD><BODY><P>seems u got answer,can u mark this thread as helpful &amp; correct?</P></BODY></HTML> Thu, 28 May 2015 14:42:40 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861240#M301440 buzzy996 2015-05-28T14:42:40Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861241#M301441 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P></P><P>Marco</P></BODY></HTML> Thu, 28 May 2015 14:46:23 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861241#M301441 marco_puccetti 2015-05-28T14:46:23Z Re: How to Order a table https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861242#M301442 <HTML><HEAD></HEAD><BODY><P>u done the good job,but how came to know tht.....tht's the answer? u have mark that one as helpful answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 28 May 2015 14:54:47 GMT https://community.qlik.com/t5/QlikView/How-to-Order-a-table/m-p/861242#M301442 buzzy996 2015-05-28T14:54:47Z