Sorting problem in pivot table in client-server

[#1]

Hi

I have a problem with a pivot table, where the lower dimension is sorted by an expression (desc).

When openning the model localy with the desktop, the sort order is OK.

When using client-server, the sorting is not correct - '0' values come before larger values..

Attaches is a pdf file with both print screens, and the expression on which the sorting is made is circled.

Does any one have an idea? maybe a bug? Im using QV11 SR1

Thanks

[#2]

Could you paste that expresion here?

[#3]

thats a simple expression:

sum(TURNOVER)

[#4]

what is the expression in that column? (ACT Gross T/O 2012)

[#5]

Thats the same expression

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.

[#6]

where is the brand dimension on seceond screen?

[#7]

I have the exact same issue!!!

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

A solution for this would be greatly appreciated

[DoS]

Hi,

I'm also having the same problem, has there been a solution found?

It would be greatly appreciated.