topic NPrinting Sort issue in Pivot table in Qlik NPrinting

NPrinting Sort issue in Pivot table

dafnis14 — Tue, 12 Jul 2016 11:42:45 GMT

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!

Tue, 12 Jul 2016 11:48:56 GMT

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

dafnis14 — Tue, 12 Jul 2016 14:59:43 GMT

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!