topic Re: Diferent sort same match() in QlikView https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641585#M235051 <HTML><HEAD></HEAD><BODY><P>Wow, I feel sorry for you already. You're missing all these thousands of bug fixes, new features and performance improvements.</P><P></P><P>If I remember correctly, there were some sorting problems in pivot tables with QV versions before 9 or even with v9 itself. Any chance of an upgrade?</P><P></P><P>Sorry I coudn't help you out.</P></BODY></HTML> Thu, 05 Jun 2014 21:26:06 GMT Peter_Cammaert 2014-06-05T21:26:06Z Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641577#M235043 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Help me with this please,</P><P></P><P>I got the same formula but qlikview thrown different sort in pivot. I need the same sort "listbox"</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 05 Jun 2014 19:56:38 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641577#M235043 pgalvezt 2014-06-05T19:56:38Z Re: Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641578#M235044 <HTML><HEAD></HEAD><BODY><P>What do you mean? You already have the exact same sort order as the listbox, but the pivot lacks some items because the expression produces a 0 value. Disable the "Suppress zero values" checkbox in Properties-&gt;Presentation and your pivot table will match the listbox.</P></BODY></HTML> Thu, 05 Jun 2014 20:11:20 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641578#M235044 Peter_Cammaert 2014-06-05T20:11:20Z Re: Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641579#M235045 <HTML><HEAD></HEAD><BODY><P>Hi, thank you for your reply.</P><P></P><P>I disabled <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">the "Suppress zero values" </SPAN>but stll show differents sorts. (I have the same formula) I will expect the same result.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 05 Jun 2014 20:19:11 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641579#M235045 pgalvezt 2014-06-05T20:19:11Z Re: Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641580#M235046 <HTML><HEAD></HEAD><BODY><P>Can you post a screenshot of what you are seeing? It appears that the document alone will not explain your trouble.</P></BODY></HTML> Thu, 05 Jun 2014 20:23:18 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641580#M235046 Peter_Cammaert 2014-06-05T20:23:18Z Re: Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641581#M235047 <HTML><HEAD></HEAD><BODY><P>When looking at your Sort expression, I can see that it has one additional item that doesn't appear in either your pivot table or your list box. If the field cc_group_desc has no value called 'OTROS INGRESOS DE LA EXPLOTACION' (see listbox) then QlikView obviously can't show it. But apart from that, the sort order is correct.</P><P></P><P>See below:</P><P></P><P><IMG alt="UnWrong Sort Order.jpg" class="jive-image" src="/legacyfs/online/60193_UnWrong Sort Order.jpg" style="width: 620px; height: 189px;" /></P></BODY></HTML> Thu, 05 Jun 2014 20:37:31 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641581#M235047 Peter_Cammaert 2014-06-05T20:37:31Z Re: Re: Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641582#M235048 <HTML><HEAD></HEAD><BODY><P>I attached the screen</P></BODY></HTML> Thu, 05 Jun 2014 20:48:13 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641582#M235048 pgalvezt 2014-06-05T20:48:13Z Re: Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641583#M235049 <HTML><HEAD></HEAD><BODY><P>I'm a bit clueless at the moment.</P><P>The same document has a different sort order (that cannot be explained) in your desktop as in mine...</P><P></P><P>What version of QV Desktop are you using?</P></BODY></HTML> Thu, 05 Jun 2014 21:05:17 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641583#M235049 Peter_Cammaert 2014-06-05T21:05:17Z Re: Re: Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641584#M235050 <HTML><HEAD></HEAD><BODY><P>8.5</P></BODY></HTML> Thu, 05 Jun 2014 21:07:40 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641584#M235050 pgalvezt 2014-06-05T21:07:40Z Re: Diferent sort same match() https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641585#M235051 <HTML><HEAD></HEAD><BODY><P>Wow, I feel sorry for you already. You're missing all these thousands of bug fixes, new features and performance improvements.</P><P></P><P>If I remember correctly, there were some sorting problems in pivot tables with QV versions before 9 or even with v9 itself. Any chance of an upgrade?</P><P></P><P>Sorry I coudn't help you out.</P></BODY></HTML> Thu, 05 Jun 2014 21:26:06 GMT https://community.qlik.com/t5/QlikView/Diferent-sort-same-match/m-p/641585#M235051 Peter_Cammaert 2014-06-05T21:26:06Z