topic Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release in Qlik NPrinting

NPrinting Table Excel Template returns the wrong columns after June 2018 Release

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

After we installed the June 2018 release of both Qlik Sense Server and NPrinting, I'm having an issue with an NPrinting Excel report. This report ran fine before our upgrade (two days ago) and there have been no changes since then to either the connected Sense app or the NPrinting template.

So the issue - I'm pulling specific columns out of a table and dropping them into cells of the template, and it returns the wrong column (a column of text where I'm trying to get it to pull a formula).

And yes, I have re-cached the connection to the app, and I've even removed that table from the template and re-added it. It's still wrong every time. For the life of me, I can't get it to display the proper columns where I want them.

Anyone else experiencing this?

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

earlowens — Thu, 19 Jul 2018 16:04:44 GMT

As I'm testing this further, the column from the table that it actually pulls seems random depending on what order I drop it in Excel. So it's not even consistent with which column from the Sense table that it returns.

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

Lech_Miszkiewicz — Fri, 20 Jul 2018 00:21:18 GMT

looks like a case for Qlik support....

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

earlowens — Fri, 20 Jul 2018 15:58:30 GMT

So after a lot more troubleshooting and testing, I ended up recreating the object in the app that was causing the problem and pulling that new object into my NPrinting report. This corrected the problem.

The tip-off that this might fix it was that I tested it with a new NPrinting App connected to a different Qlik Sense app and I wasn't able to recreate the issue there. But if I created a new NPrinting App (and connection) to that same Sense App and object, it kept happening.

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

Lech_Miszkiewicz — Mon, 23 Jul 2018 01:38:25 GMT

Still i think it is a case for Qlik to investigate. If you can re-create an issue maybe it is worth pointing it to R&D that something like this happens.

Many customers will move/upgrade from older versions of Qlik & NPrinitng to newer ones soon and they will likely experience the same.

Ruggero, Daniel what do you reckon guys?

djk‌ rpc‌

thanks

Lech

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

Anonymous — Wed, 25 Jul 2018 08:15:52 GMT

Hi Earl,

I am facing the same issue, although after upgrade to April QS. I also did a lot of testing and troubleshooting, but your solution hasn't worked for me - I tried creating everything from scratch, thus QS app with completely new data (just one simple qvd), new Nprinting App, new filter, new report. Still having the issue... I found another two workarounds

use a whole table as an object in QS
the table in QS must have the columns in specific order - firstly all dimensions, then measures.

The problem arises as soon as there are "mixed" dimensions and measures between each other (e.g. having

| dim | dim | measure | dim | measure |...

Does creating from scratch work for you even when having this "mixed" column types?

(btw I am describing my issue in details here, if it's not clear : Nprinting wrong columns order in table with expressions and dimensions

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

Ruggero_Piccoli — Wed, 25 Jul 2018 09:32:54 GMT

Hi,

First of all, update to latest version June 2018 and test with it. You can do a direct update: download and install June 2018 setups and run them. In this way all your Qlik NPrinting entities will be preserved.

If you still have the issue with June 2018, please open a support case. Include the app that is giving you the issue and all useful details like the Qlik Sense and NPrinting version, and what you to to recreate the issue.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

Ruggero_Piccoli — Wed, 25 Jul 2018 09:59:35 GMT

Hi,

Please open a support case in order to let us to investigate. Please include the apps that generate the issue and the one that works. Add also all the details we need to be able to recreate the issue.

Best Regards,

Ruggero

---------------------------------------------

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

Anonymous — Wed, 25 Jul 2018 11:30:13 GMT

Hi Ruggero,

thanks for your input, I'll try with the June version, in case it is still not working, we'll set up a case I guess

Simona

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

earlowens — Wed, 25 Jul 2018 13:11:35 GMT

Hi Simona,

The particular table that was giving me trouble is indeed a "mixed" order table, but it was actually kind of necessary that the table be laid out this way. We also don't want to include all columns from the table in the scheduled distribution since it's just supposed to be a summary. We are on the June 2018 release, and recreating the object exactly as it was (still "mixed" order of dimensions and measures) did correct the issue, thankfully. The scheduled distribution of this report went out over the weekend and was fine.

Hopefully moving up to the latest version will help!

Earl

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

Anonymous — Wed, 25 Jul 2018 13:23:36 GMT

Hi Earl,

yes, we have exactly that case, we also need it mixed - I tested in my environment on June version and it seems to be improved, so we'll upgrade the other environment this week and hopefully everything will work

Thank you for the feedback about your reports!

Simona

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

dwforest — Tue, 05 Mar 2019 00:20:18 GMT

So if you can't upgrade (currently on Nov 2017), is there any solution?
Current state seems to be, you cannot modify a Qlik Sense table used as a NPrinting source if it contains measures and dimensions?
I've created a new table/object and it will still not pull in the correct fields .

Re: NPrinting Table Excel Template returns the wrong columns after June 2018 Release

pwagner — Fri, 20 Sep 2019 08:53:13 GMT

Hello,

it seems this issue pops up again with NPrinting June 2019 (19.19.4.0).

Anyone have seen this issue with this version?

Best regards, Patrick