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?
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.
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).
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?
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