Sort Order in a Pivot Table with Section Access on Ajax is incorrect
Article Number: 000044315 | Last Modified: 2018/06/12
In some cases the sort order in a QlikView document with section access containing a pivot table might be wrong.
For instance a pivot table is sorted in descending order according to numeric values: Positive numbers are at the top, zeroes in the middle and negative numbers at the bottom.
The table is shown correctly when it is opened in QlikView Desktop but when opened in the Access Point, the zeros are at the bottom and negative numbers are in the middle.
This issue has been reported to R&D with the BUG ID QV-6261. However, a decision has been made that the defect won't be fixed due to the low severity and priority of the case.
A potential work around is to use Sort by Expression in the pivot table properties in order to adjust the sorting.