topic Sorting problem in pivot table in client-server in QlikView https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376164#M140202 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a problem with a pivot table, where the lower dimension is sorted by an expression (desc).</P><P>When openning the model localy with the desktop, the sort order is OK.</P><P>When using client-server, the sorting is not correct - '0' values come before larger values..</P><P>Attaches is a pdf file with both print screens, and the expression on which the sorting is made is circled.</P><P></P><P>Does any one have an idea? maybe a bug? Im using QV11 SR1</P><P></P><P>Thanks</P></BODY></HTML> Wed, 08 Aug 2012 12:23:08 GMT 2012-08-08T12:23:08Z Sorting problem in pivot table in client-server https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376164#M140202 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a problem with a pivot table, where the lower dimension is sorted by an expression (desc).</P><P>When openning the model localy with the desktop, the sort order is OK.</P><P>When using client-server, the sorting is not correct - '0' values come before larger values..</P><P>Attaches is a pdf file with both print screens, and the expression on which the sorting is made is circled.</P><P></P><P>Does any one have an idea? maybe a bug? Im using QV11 SR1</P><P></P><P>Thanks</P></BODY></HTML> Wed, 08 Aug 2012 12:23:08 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376164#M140202 2012-08-08T12:23:08Z Re: Sorting problem in pivot table in client-server https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376165#M140203 <HTML><HEAD></HEAD><BODY><P>Could you paste that expresion here?</P></BODY></HTML> Wed, 08 Aug 2012 13:10:17 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376165#M140203 2012-08-08T13:10:17Z Re: Sorting problem in pivot table in client-server https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376166#M140204 <HTML><HEAD></HEAD><BODY><P>thats a simple expression:</P><P>sum(TURNOVER)</P></BODY></HTML> Wed, 08 Aug 2012 13:13:43 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376166#M140204 2012-08-08T13:13:43Z Re: Sorting problem in pivot table in client-server https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376167#M140205 <HTML><HEAD></HEAD><BODY><P>what is the expression in that column? (ACT Gross T/O 2012)</P></BODY></HTML> Wed, 08 Aug 2012 13:33:19 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376167#M140205 2012-08-08T13:33:19Z Re: Sorting problem in pivot table in client-server https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376168#M140206 <HTML><HEAD></HEAD><BODY><P>Thats the same expression</P><P>I want to sort MODEL dimension acording to ACT Gross T/O 2012, and because this is a pivot table the sorting is made via 'expression' sort option.</P></BODY></HTML> Wed, 08 Aug 2012 13:39:19 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376168#M140206 2012-08-08T13:39:19Z Re: Sorting problem in pivot table in client-server https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376169#M140207 <HTML><HEAD></HEAD><BODY><P>where is the brand dimension on seceond screen?</P></BODY></HTML> Wed, 08 Aug 2012 13:49:26 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376169#M140207 2012-08-08T13:49:26Z Re: Sorting problem in pivot table in client-server https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376170#M140208 <HTML><HEAD></HEAD><BODY><P>I have the exact same issue!!!</P><P>On the Server Version of my QlikView solution my sort filters work on the Pivot Table but in the Published version on Internet Explorer, the Sort Function ignores all values with a "0" and puts these line items above those line items with a value. The sort functions however do work but only on those items that have an actual value</P><P></P><P>A solution for this would be greatly appreciated</P></BODY></HTML> Tue, 14 Aug 2012 17:54:19 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376170#M140208 2012-08-14T17:54:19Z Re: Sorting problem in pivot table in client-server https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376171#M140209 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm also having the same problem, has there been a solution found?</P><P></P><P>It would be greatly appreciated.</P></BODY></HTML> Thu, 06 Dec 2012 10:56:40 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-in-pivot-table-in-client-server/m-p/376171#M140209 DoS 2012-12-06T10:56:40Z