topic How to sort data according to expression values in QlikView https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/316000#M584956 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to disselect other Dimension if it is selected in sort tab.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Thu, 01 Sep 2011 10:18:36 GMT its_anandrjs 2011-09-01T10:18:36Z How to sort data according to expression values https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/315996#M584952 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i need to sort my results in pivot table according to the expression calculated.. please have a look in the table given below.. i want to sort it out according to the <STRONG>Total Qty </STRONG>in descending order from top to bottom.. </P><P></P><P>Please help me out to solve this problem..</P><P></P><P><IMG __jive_id="6920" alt="TABLE.JPG" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/6920_TABLE.JPG" width="450" /></P></BODY></HTML> Thu, 01 Sep 2011 08:41:42 GMT https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/315996#M584952 sushil353 2011-09-01T08:41:42Z How to sort data according to expression values https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/315997#M584953 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Please add your experience to solve this problem.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 01 Sep 2011 09:12:40 GMT https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/315997#M584953 sushil353 2011-09-01T09:12:40Z How to sort data according to expression values https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/315998#M584954 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>As i understand you want to sort the chart by <STRONG style="font-size: 12px;">Total Qty</STRONG> Field, you need to set sort order in </P><P>Chart Properties -&gt; Sort -&gt; CheckMark Expression -&gt; Select descending order from list and in below window type <STRONG style="font-size: 12px;">Total Qty </STRONG>Expression what ever it is and apply the conditon. </P><P></P><P>Hope this helps you</P><P></P><P>Regards,</P><P>Anand</P></BODY></HTML> Thu, 01 Sep 2011 09:24:00 GMT https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/315998#M584954 its_anandrjs 2011-09-01T09:24:00Z How to sort data according to expression values https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/315999#M584955 <HTML><HEAD></HEAD><BODY><P>Hi Anand,</P><P></P><P>Thanks for your reply, I made changes according to your suggestion. but it is working please find the attached screenshot</P><P></P><P><IMG alt="table3.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/6921_table3.JPG" width="450" /></P></BODY></HTML> Thu, 01 Sep 2011 10:02:52 GMT https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/315999#M584955 sushil353 2011-09-01T10:02:52Z How to sort data according to expression values https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/316000#M584956 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to disselect other Dimension if it is selected in sort tab.</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Thu, 01 Sep 2011 10:18:36 GMT https://community.qlik.com/t5/QlikView/How-to-sort-data-according-to-expression-values/m-p/316000#M584956 its_anandrjs 2011-09-01T10:18:36Z