topic Re: NP17 sort qliksense pivot table inside of level in Qlik NPrinting

NP17 sort qliksense pivot table inside of level

jrromito — Tue, 14 Jan 2020 14:32:54 GMT

I need help in sorting a nPrinting report. I am using nPrinting June 2019 with a qlik sense app. I have added a level and a table. The table is based on pivot chart from qlik sense application. In the pivot table, the first column is sorted alphabetically DESC (z→a), and in the nPrinting report it sorts ASC (a→z). The desired result is a DESC sort. I have seen similar posts to this where the marked 'solved' response is to sort the source object, but this is not working. Is it because of pivot table? I need subtotals. I could add more levels and reduce the number of dims for the table to achieve the same result, but not sure if this will work and it seems sorting with this method should be an option. Any help greatly appreciated!

The nPrinting template looks like this:

<level>

</level>

Re: NP17 sort qliksense pivot table inside of level

Lech_Miszkiewicz — Tue, 14 Jan 2020 22:58:17 GMT

What is the version of Qlik Sense - it may be quite important for replicating your issue.

Things I would try:

after setting proper default sort order in your table chart properties in Qlik Sense regenerate metadata
this is only suggestion but i would also try to load field values in your data model in required order to assign the correct pointer/index to each value you have in this column. This is very common practice i use for sorting and it is based on the same principles as this: https://community.qlik.com/t5/New-to-Qlik-Sense/Customize-sort-order/td-p/1103644 The difference is that not always i can use INLINE load as there may be variable values in the column i need to sort on. So then I use order by method in load. My pivot table would be then sorted using Load Order method: https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/change-sorting-of-visualization.htm#anchor-2

Re: NP17 sort qliksense pivot table inside of level

jrromito — Thu, 16 Jan 2020 19:22:14 GMT

Qlik Sense version is November 2019. I have tried reloading metadata and that did not work. I sorted the dimensional table and reloading metadata again... that did not work, either.