topic Re: Qlikview table columns and data order are wrong in NPrinting in Qlik NPrinting

Qlikview table columns and data order are wrong in NPrinting

brenests77 — Tue, 17 Mar 2020 20:40:38 GMT

Hi community,

We have a couple of reports on NPrinting with this issue:

- Qlikview table:

- Nprinting template:

Report generated On Demand:

As you can see, the data does not match the columns. Any idea about this issue?

We have QlikView and NPrinting, both in April 2019 version.

Kind regards.

Re: Qlikview table columns and data order are wrong in NPrinting

Frank_S — Wed, 09 Oct 2019 20:02:03 GMT

Hi @brenests77

Please check the solution mentioned in another thread as what you are experience appears to be the same issue.

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Header-and-values-of-columns-mixed-up-in-NPrinting-June-2019/m-p/1626426/highlight/true#M26054

Kind regards...

Re: Qlikview table columns and data order are wrong in NPrinting

Lech_Miszkiewicz — Wed, 09 Oct 2019 23:12:00 GMT

Make sure all columns are visible, there is no conditional hide/show on them!

Re: Qlikview table columns and data order are wrong in NPrinting

brenests77 — Wed, 09 Oct 2019 23:29:40 GMT

Hi @Frank_S
I try to update each individual column table field by right click and 'update' on NP Designer but thats not possible, at least in April 2019 version, only update all table object is allowed.

Regenerating the metadata and deleting and inserting the column fields of the affected table again individually does not work either.

Kind regards...

Re: Qlikview table columns and data order are wrong in NPrinting

waterscg — Thu, 10 Oct 2019 14:34:31 GMT

I began encountering a very similar issue after installing QlikView 12.4 SR1. Upgrading to a post-SR1 patch (supplied by Qlik Support, and planned for inclusion in an upcoming update) resolved the issue.

Re: Qlikview table columns and data order are wrong in NPrinting

Frank_S — Thu, 10 Oct 2019 16:25:35 GMT

@waterscg @brenests77

Just a note of caution.

Upgrading the QV desktop exclusively on the NP server is not advisable unless you are upgrading the QlikView server concurrently. Further, having multiple higher and lower different versions of QV desktop in your environment could cause QVW corruption when QVWs are saved in different higher and lower versions of QV desktop.

@brenests77

Please also check the part of the article which talks about the presentation tab and general tab.

"Open the QVW and check that the affected chart properties to ensure that the positions of the chart match those found in the 'presentation' tab."

These 'can' get out of alignment when you drag a dimension or expression to a different position directly on the chart object itself.

Check this and ensure that the chart dimension/expressions match those on the presentation tab. Then expand the plus sign.

If the chart properties/dimension/expressions were already matching order with those in the Presentation Tab, then we should have a closer look at the issue for you. Please submit a support request to your Qlik Support desk or your responsible Qlik Support partner.

Kind regards...

Re: Qlikview table columns and data order are wrong in NPrinting

Ruggero_Piccoli — Fri, 11 Oct 2019 08:09:27 GMT

Correct. Go back to QlikView 12.20 or older until we will release an official solution.

Best Regards,

Ruggero