topic Re: sorting problem in QlikView https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372450#M138502 <HTML><HEAD></HEAD><BODY><P>I know why but I don't know how to fix it.</P><P>We have Vendors name which belong to different Expense type.</P><P>so it crashes the sorting but I don't know what to do <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P>Any idea is appreciated.</P><P></P><P>if you select the not sorted one you will see it !!!!</P></BODY></HTML> Fri, 27 Jul 2012 19:02:15 GMT 2012-07-27T19:02:15Z sorting problem https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372448#M138500 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Could any body tell me why my sorting is not good?</P><P>if you look at the 5th rows of the cross tab you'll see that is not sorted in total.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 27 Jul 2012 18:25:09 GMT https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372448#M138500 2012-07-27T18:25:09Z Re: sorting problem https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372449#M138501 <HTML><HEAD></HEAD><BODY><P>really amazing... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 27 Jul 2012 18:56:41 GMT https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372449#M138501 giakoum 2012-07-27T18:56:41Z Re: sorting problem https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372450#M138502 <HTML><HEAD></HEAD><BODY><P>I know why but I don't know how to fix it.</P><P>We have Vendors name which belong to different Expense type.</P><P>so it crashes the sorting but I don't know what to do <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P>Any idea is appreciated.</P><P></P><P>if you select the not sorted one you will see it !!!!</P></BODY></HTML> Fri, 27 Jul 2012 19:02:15 GMT https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372450#M138502 2012-07-27T19:02:15Z Re: sorting problem https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372451#M138503 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Use sort by expression as</P><P>= Sum(Total&lt;EXPENSE_TYPE,VENDOR_NAME&gt; {$&lt;VENDOR_NAME=&gt;}&nbsp; AP_TRAN_TOTAL_CURRENCY)</P></BODY></HTML> Fri, 27 Jul 2012 19:45:28 GMT https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372451#M138503 CELAMBARASAN 2012-07-27T19:45:28Z Re: sorting problem https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372452#M138504 <HTML><HEAD></HEAD><BODY><P>Thanks for replying but it does not work this way too.</P></BODY></HTML> Sun, 29 Jul 2012 18:53:51 GMT https://community.qlik.com/t5/QlikView/sorting-problem/m-p/372452#M138504 2012-07-29T18:53:51Z