Qlikview table columns and data order are wrong in NPrinting

[brenests77]

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.

[Frank_S · Accepted solution]

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-NP...

Kind regards...

[Lech_Miszkiewicz]

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

[brenests77]

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...

[waterscg]

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.

[Frank_S]

@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...

[Ruggero_Piccoli]

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

Best Regards,

Ruggero