NPrinting Sort issue in Pivot table - Qlik Community

dafnis14 · ‎2016-07-12

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):

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

Any idea how to resolve this?

Thanks!

Report Inappropriate Content · ‎2016-07-12

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

dafnis14 · ‎2016-07-12

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.

Thanks!