The sort order in a table is not correct after the upgrade to QlikView 12.10Article Number: 000038004 | Last Modified: 2020/02/24
The sort order in the tables has changed after an upgrade to a QlikView 12.10 version from QlikView 11.20 or 12.00. Data is sorted according to the dimension if if the table was set to be sorted according to an expression.
QlikView 12.20 (November 2017) and up
As you can see, in QlikView 11.20, the sort order has the expressions at the top. This means that the data sorting is based on the expression values (notice also that only the expression set by the condition is shown in QV 11.20).
QlikView 12.10 / 12.20:
The dimension is automatically set at the top in the Sort order when the same document is opened using QlikView 12.10.
This means that the data sorting in the table is wrong in that version.
This means that all charts from earlier versions that contained disabled/hidden columns got their sort order reset to default when opening in 12.10.
1. Check the "Allow interactive sort" property in the Chart Properties > Sort. Each user will have the possibility to change the sort order directly from the table by clicking on the column name.
2. Change the sort order in the Priority box manually in the Chart Properties > Sort for each table.
3. Save the QVW and republish from the QMC if needed
4. Reload the NPrinting connection metadata to the QVW if the QVW is used with NPrinting
For tips and tricks and examples on advanced app development, join our active Qlik Community.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.