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: 
jonastemin
Contributor II
Contributor II

nPrinting 17 Excel output columns shifted

Hi,

I have a table (Chart Straight Table) that I want to output in nPrinting.

Problem is that the data columns gets shifted one column to the left.

Has anyone experienced this problem in nPrinting 17 and Qlikview 12?

Designer File:

exampleN1.jpg

Output File:

exampleN2.jpg

This worked just fine in previous version of nPrinting.

Regards,

Jonas

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi

I had the same situation. In my case it was related to hidden Dimensions or Measures in my source QlikView chart table.

I ended up keeping all columns visible and everything started working as expected.

Regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

5 Replies
ogster1974
Partner - Master II
Partner - Master II

Looking at your example the Show header is set to hide and yet in your preview the custname is visible.  PErhaps your issue is related.  try not hiding the column header and see if your data returns.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi

I had the same situation. In my case it was related to hidden Dimensions or Measures in my source QlikView chart table.

I ended up keeping all columns visible and everything started working as expected.

Regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
jonastemin
Contributor II
Contributor II
Author

This resolves this issue but I does mean that my Qlikview applikation needs to show all columns which is annoying.

Regards,

Jonas

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

That is true,

However as a best practice usually you have dedicated sheet (visible only for NPrinting user) with copies of objects you utilize in NPrinting reporting. This then is not visible for end users and it is not so much annoying anymore.

My best practice though is to have dedicated for NPrinting reporting QlikView application. This is usually loaded only with fields and objects i need for reporting which then  works usually much faster and is easier to work with. This also is not affecting my application used by users. I know it is "double work" as you need to maintain 2 applications but from performance point of view is much better solution. I usually use binary load or full optimized QVD load to feed source to NPrinting QlikView App

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
kdmarkee
Specialist
Specialist

I also experienced this (NP 17.5) but it was not due to hidden columns in my chart.  In my case, it turned out to be that when I changed the order of the columns in my chart, republished it to Access Point, reloaded the metadata in NP, and then updated my chart in the NP report designer, it didn't render the column order correctly.  I had to remove the chart from the Tables node in NP designer and re-add it, and also remove and re-add the columns to the excel layout.