Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
adria
Contributor II
Contributor II

NPrinting Excel Template for QV straight table puts data in wrong columns

We started experiencing problems with the data generated into a couple of our NP reports switching around once we upgraded our QlikView server a couple weeks ago. 

Here's how it's rearranging things:

QV chart columns (plain 'ol straight table): 1, 2, 3, 4, 5, 6, 7, 8

template: (same order as QV chart, no extra formatting)

data in executed report: 1, 2, 6, 7, 8, 3, 4, 5

It's just the data that's getting confused about where to go. The column headings are just fine. The data reference in the template will say "Price" for example, but instead it pulls in the "Month" data from a different column in the chart.

I've tried the reload/regenerate dance and even deleted then recreated the template. Still no dice.

Any ideas on what might be going on? 

 

System info: QV 12.4 SR1 (April 2019); NPrinting June 2019

1 Solution

Accepted Solutions
adria
Contributor II
Contributor II
Author

@Ruggero_Piccoli & @Daniel_Jenkins & @Frank_S 

Well... silence the alarms. I should have more thoroughly searched the knowledge database because this is due to a known bug.

In this case the presentation tab in the object got out of sync and has the columns listed out order (but in the order that they're appearing in the output.) It's a little weird that this object is producing a fine result in another template that doesn't use all the columns, but whatever.

The solution is to either move the columns to match the order in the presentation tab or to recreate the object.

I appreciate all of your help in brainstorming what could possibly be happening.

Thanks.

Adria

View solution in original post

7 Replies
Ruggero_Piccoli
Support
Support

Hi,

This is very strange. Could you post some screenshots of the template and the results? We need to have more details to understand what is happening.

Are you sure that the source object is not changed? Did you upgraded the object in the template?

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Frank_S
Support
Support

Try this:

  • open the NP template editor for one of the affected reports
  • right click on the tables node
  • right click on each individual table one at a time and select 'update' from the context menu.

This table update process in the template editor should update any columns that may have changes recently in your source QVWs.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
adria
Contributor II
Contributor II
Author

Hi Ruggero,

It is strange indeed. These are the columns in the chart and "updating" the chart in the template doesn't come up with any results. The table fields' properties are all checked to keep source formats and "hide" on "show header".

Below are examples of the template and (manually scrambled) output.


TemplateTemplate

 

ExportExport

 

Daniel_Jenkins
Specialist III
Specialist III

Hi @adria ,

In the source QVW, do you have hidden or conditionally hidden/shown columns in the table?

Can you share a copy of the QVW? If so please reduce and scramble (make sure it is a copy) before posting here.

Thanks - Daniel.

Ruggero_Piccoli
Support
Support

Hi,

Another test I suggest is to remove the special characters / and () from the gain /(loss) field in the QVW. Maybe you can call the field GainLoss or similar and try again. I have no info about a similar problem, so it is an investigation to exclude it.

Thanks

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
adria
Contributor II
Contributor II
Author

@Daniel_Jenkins 

Nothing hidden or conditional. There is a calculated dimension for "Future Maturity Month Year" = text([Future Maturity Month Year]).  I know those aren't ideal, but it's a remnant of trying to fix the number format from incorrectly flowing into another template.

 

Attaching a scrambled & reduced copy.

 

Thanks.

adria
Contributor II
Contributor II
Author

@Ruggero_Piccoli & @Daniel_Jenkins & @Frank_S 

Well... silence the alarms. I should have more thoroughly searched the knowledge database because this is due to a known bug.

In this case the presentation tab in the object got out of sync and has the columns listed out order (but in the order that they're appearing in the output.) It's a little weird that this object is producing a fine result in another template that doesn't use all the columns, but whatever.

The solution is to either move the columns to match the order in the presentation tab or to recreate the object.

I appreciate all of your help in brainstorming what could possibly be happening.

Thanks.

Adria