topic Re: Nprinting Error Message in Qlik NPrinting

Nprinting Error Message

Thu, 20 Aug 2015 19:09:29 GMT

I am getting this error when trying to generate a preview of my excel Nprinting document 'Index was outside the bounds of the array'. I have an excel with several worksheets that have pivot tables in them. The pivot tables are referencing the same fields of Carrier, Plan Name, and Age, but then each pivot table reference a different Rate that is a separate field in the original table. Can you help me figure out why I may be getting this error?

Re: Nprinting Error Message

Stephen_Jasionowski — Thu, 20 Aug 2015 19:26:21 GMT

Alissa -

What version of NPrinting are you using? We have seen this error and made a bug fix for it in NP16 SR1. You can download that version, along with the release notes documenting this from the Qlik downloads page (see QlikView tab): http://us-b.demo.qlik.com/download/

If you are that version or a more recent service release, please contact Qlik Support regarding this error.

Re: Nprinting Error Message

Thu, 20 Aug 2015 19:43:12 GMT

Unfortunately that is the version that we are currently on. I will contact Qlik Support.

Re: Nprinting Error Message

Wed, 26 Aug 2015 12:22:15 GMT

could you provide the sample nsq with the template and qvw?

Re: Nprinting Error Message

Wed, 26 Aug 2015 16:29:38 GMT

Just wanted to include some new information:

1. We upgraded to Nprinting 16.2 today and I am still getting the error message.

2.What is happening is that on my pivot tables, I have a field filter applied to two fields(see screen shot below).

3.That filter for both fields is ‘Does Not Equal…’ and the value is set to zero(see screen shot below).

4. If I remove the Plan filter and keep the Age filter I no longer get the error message. If I removed the Age filter and keep the Plan filter, I get the error message.

5.But I need both filters in there so that I don’t get a column of Zero’s and I don’t get a row of Zero’s in the table. The example below is what it looks like when I remove the Plan filter. There is a blank column inserted at the end of the table, but there is no blank row at the bottom(which is what I want for both the row and column at the end of the table).

Thoughts?

Re: Nprinting Error Message

Wed, 26 Aug 2015 16:45:59 GMT

If I understand correctly, you have a straight table in QlikView and then converted it into a Pivot table within the NPrintinting Excel template?

I was initially thinking the filters were within Nprinting but they are within the Pivot table itself

would it make sense to add filters within NPrinting?

Re: Nprinting Error Message

Andrea_Ghirardello — Thu, 27 Aug 2015 15:32:46 GMT

Hi, you need to change the settings of the pivot table from within the Template Editor as explained here (section "Set Data to Be Refreshed"): How to Create a Pivot Table from Excel Table Columns – Customer Feedback for Vizubi

Otherwise you will see the "tag" values and temporary values available in design time.

Re: Nprinting Error Message

Mon, 31 Aug 2015 16:30:31 GMT

So the upgrade didn't work, and neither did 'Set Data to be Refreshed'. Also, I am actually getting that error message now even without the filters. I have three separate pivot tables that are made using three separate straight tables. Any other ideas?

Re: Nprinting Error Message

Mon, 31 Aug 2015 17:57:24 GMT

I have never run into this issue but the straight tables I have converted to Pivot in the Excel tempalte were much smaller than this. Is there a particular reason in needs to be a pivot? I have had much success using levels in the Excel template isntead of using pivot tables - a possible option to think about.

If you have not done so already, you may want to set up a support call and have Qlik remote in and see what is going on

Re: Nprinting Error Message

Andrea_Ghirardello — Tue, 01 Sep 2015 07:07:36 GMT

Do you have other objects in the same sheet where you put the pivot?

If so, please try using only the pivot in the sheet.

This because Excel may not be able to expand ranges for the pivot if something else is below it in a different range with different number of columns.

Another check to perform: how many rows and/or columns will contain the final pivot? Check here Excel specifications and limits

Re: Nprinting Error Message

Tue, 01 Sep 2015 13:29:31 GMT

I do not have any other object in the sheets with the pivot tables. I am going to have a call with Support this afternoon and hopefully will get some answers.

Thank you!

Re: Nprinting Error Message

Tue, 01 Sep 2015 13:38:18 GMT

please let us know the results of your support session - very curious as to the cause of the issue

Re: Nprinting Error Message

Wed, 09 Sep 2015 16:35:49 GMT

Well, the outcome of my support call is that when using a pivot table in Nprinting, there MUST be data populated into each pivot. I had three pivot tables, and based on selections that I wanted to make in QV, I may only need data to populate into 2 of the 3 tables. This lack of data for the 3rd pivot is why I was getting the error. My workaround for this project is that I will just always populate into all 3 pivots, and the end user will just have to delete the pivot tables they do not want to use if necessary.

Re: Nprinting Error Message

Wed, 09 Sep 2015 16:55:37 GMT

Good to know - I try not to use pivot tables much in NPrinting unles I use them as an image - I seem to run into issues with them and NPrinting is limited on the pivot table when brought in as a pivot from the QV application

Re: Nprinting Error Message

stig1984 — Fri, 01 Dec 2017 14:14:11 GMT

This makes a lot of sense - I have been having this issue with an excel pivot which was working but now does not. As we have just started a new financial year the data is now all zero and the report no longer runs.

As soon as some data is populated it runs again.

Re: Nprinting Error Message

Ruggero_Piccoli — Tue, 12 Dec 2017 14:36:03 GMT

Hi Stephen,

Please let us know if you need help. This is a very old thread and it refers to Qlik NPrinting 16.

Best,

Ruggero

Re: Nprinting Error Message

stig1984 — Tue, 19 Dec 2017 16:21:35 GMT

It answered my question beautifully - thanks.

Just thought it might be a pertinent comment if anyone else was searching for the same issue - as soon as data was available the error disappeared.