topic Re: NPrinting Excel Template for QV straight table puts data in wrong columns in Qlik NPrinting

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

adria — Wed, 25 Sep 2019 18:40:54 GMT

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

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

Ruggero_Piccoli — Thu, 01 Aug 2019 14:44:46 GMT

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

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

Frank_S — Thu, 01 Aug 2019 14:59:04 GMT

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.

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

adria — Thu, 01 Aug 2019 15:45:32 GMT

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.

Template

Export

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

Daniel_Jenkins — Fri, 02 Aug 2019 01:52:30 GMT

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.

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

Ruggero_Piccoli — Fri, 02 Aug 2019 07:43:36 GMT

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

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

adria — Fri, 02 Aug 2019 13:38:45 GMT

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

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

adria — Fri, 02 Aug 2019 15:23:47 GMT

@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