Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

dafnis14
Contributor III

NPrinting Sort issue in Pivot table

Hi,

I understand that some of the issues one encounters are related to Excel and not to NPrinting.

But still.. hope someone could assist here..

I created a pivot table  and have an issue with a date sort.

I have unchecked the option "keep source format".

In the source table, the dates are sorted as expected (ascending order):

Sort1.png

But in the Pivot table, they are not sorted as expected:

Sort2.png

Any idea how to resolve this?

Thanks!

2 Replies
Not applicable

Re: NPrinting Sort issue in Pivot table

Have you tried setting the sort order of the dimension(s) in the pivot table?

dafnis14
Contributor III

Re: NPrinting Sort issue in Pivot table

Hi Aran,

It is defined to sort by the source table as I am working with one.

In the source table, the sort order is correct.

But I also tried with custom list (on the report itself), but It didn't change the order.

(https://www.extendoffice.com/documents/excel/2025-excel-pivot-table-sort-custom-list.html)

Thanks!

sort3.png