topic Re: NPrinting Excel Template Issue in Qlik NPrinting

NPrinting Excel Template Issue

Thu, 09 Mar 2017 22:29:55 GMT

I have an Excel template that currently has 15 report filters in a pivot table. I was asked to add a field, but NPrinting doesn't like it. I receive an 'Error: Attempted to divide by zero' error message. I've attached a screen shot to show what is happening.

I've tried everything I can think of to fix it. Even recreating the template, but the result is the same.

If anyone out there can verify that the NPrinting process only allows 15 report filters in a pivot table of an Excel template or has a solution to allow more, it would be much appreciated.

Re: NPrinting Excel Template Issue

Daniel_Jenkins — Thu, 09 Mar 2017 22:51:42 GMT

Hi Allan,

Can you check your OS advanced Regional Settings and ensure that these two are not set to the same symbol:

By the way, I just tried an Excel Pivot Table report with 18 report level filters and it worked just fine.

HTH - Daniel.

Re: NPrinting Excel Template Issue

Thu, 09 Mar 2017 23:03:55 GMT

Hi Daniel,

Where am I navigating to get to the screen shot you posted? Thanks

Did you create your report from an NPrinting template or did you manually create the pivot table?

I can open my template, past data in it, and put in as many report filters I want.

I think the issue lies within NPrinting not liking more than 15 when it generate a report.

Re: NPrinting Excel Template Issue

Thu, 09 Mar 2017 23:07:44 GMT

OK - after I sent the last message, I found it in the Control Panel - Region and Language. The two symbols are diferent

Re: NPrinting Excel Template Issue

Daniel_Jenkins — Thu, 09 Mar 2017 23:24:33 GMT

Hi Allan,

I'm not sure what you mean by: Did you create your report from an NPrinting template or did you manually create the pivot table? I built the pivot table in the NPrinting Excel report template. Using this method: How to Create a Pivot Table from Excel Table Columns

Also not clear how you are putting multiple filters into your template. I assumed you added them at the Report level. I did run the report Task without issues. If you list the exact steps you took, I can try to reproduce the issue and confirm. However, I suspect it has something to do with your source data. It would be great if you shared a sample project that demonstrates the issue (QVW, NSQ with the filters etc. & Excel report template). Or open a case with Tech. Support.

HTH - Daniel.

Re: NPrinting Excel Template Issue

Fri, 10 Mar 2017 20:23:15 GMT

Daniel,

Sorry I wasn't very clear. What I should have asked you is if you created the report from the nsq executing a report task, and you indicated that you had. And it's that report you indicated you had 18 report filters, correct?

I'm attaching my report template, nsq and qvw. I had to remove the data from the qvw, so hopefully you can create dummy data to get this all to work together. That is if you have the time.

Re: NPrinting Excel Template Issue

Daniel_Jenkins — Sat, 11 Mar 2017 22:57:59 GMT

Hi Allan,

"... I suspect it has something to do with your source data"

Without the data I'm afraid I cannot reproduce the issue so I have nothing to work with.

- Daniel.

Re: NPrinting Excel Template Issue

Thu, 23 Mar 2017 14:33:53 GMT

A solution has been found. The setting 'Display fields in report filter area:' was changed from 'Down, Then Over' to 'Over, Then Down.