topic Re: NPrinting final report using excel filters in Qlik NPrinting

NPrinting final report using excel filters

eleni_theodorid — Wed, 30 May 2018 09:46:07 GMT

Hi all,

I am using NPrinting 17, I use a qlik table and I need at the final excel report that I am sending via email the user has the option to filter that table by Region. How can I connect my table with excel filters?

Regards,

Eleni

Re: NPrinting final report using excel filters

Lech_Miszkiewicz — Wed, 30 May 2018 12:45:21 GMT

Hi,

apologies but I don't understand your question.

What does it mean excel filter? When the report gets to end user in Excel form it is just excel file - there is no link back to qlik or nprinting - it is just excel!

So now, what are you asking? Are you asking how to turn on filter in Excel Table?

cheers

Lech

Re: NPrinting final report using excel filters

eleni_theodorid — Wed, 30 May 2018 15:47:25 GMT

Hi Lech,

To be clear: I need to create a pivot table in excel using data from qlik next to that pivot I need to create a filter field which gets data from qlik (Region) and give to the user the option to filter the pivot. Region is not a pivot column.

I hope that helps.

Regards,

Eleni

Re: NPrinting final report using excel filters

Lech_Miszkiewicz — Thu, 31 May 2018 03:23:10 GMT

Well in this case you need to create a table in Qlik which will contain also region in it as you then need to slice and dice it by region in excel. The output from Qlik to Excel needs to be a SINGLE TABLE with all fields required for filters, columns, rows, slicers etc... for your pivot table

The second part is simple excel exercise to build pivot table from the source table.

Go throught the topics below.

nprinting Excel with Pivot

Nprinting Pivot report Filter issue

cheers

Lech

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

When applicable please mark the appropriate replies as CORRECT. 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 final report using excel filters

eleni_theodorid — Tue, 05 Jun 2018 08:28:51 GMT

Hi Lech,

Thank you for your help. That's exactly what I need to create. I have created the table, convert it in excel pivot, create the slicer but when I am trying to run the task to see results the task fails with Warn Failed report generation for report ... exception System.Exception: unknown: STACK: . Any idea?

Regards,

Eleni

Re: NPrinting final report using excel filters

Ruggero_Piccoli — Tue, 05 Jun 2018 08:44:17 GMT

Hi,

We have to few information:

- what version of Qlik NPrinting are you using?

- could you share a screenshot of your template?

- could you share the complete logs of the error?

- did you followed these instructions step by step https://help.qlik.com/en-US/nprinting/April2018/Content/ExcelReports/Pivot-table-Excel.htm?

- did you added filters to the report? what happens if you remove the filters?

- if you add only the Excel table, witout creating the pivot, and you run a preview will it work correctlly?

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 final report using excel filters

eleni_theodorid — Tue, 05 Jun 2018 10:03:49 GMT

Hi Ruggero,

Qlik NPrinting version is 17 November 2017. I recreate the connection and the System. Exception: unknown: STACK: resolved, but the report created empty. Then I tried to remove slicers and the report created successfully. Any ideas why slicers causinfg issues and how I can resolve them?

Regards,

Eleni

Re: NPrinting final report using excel filters

Ruggero_Piccoli — Tue, 05 Jun 2018 10:17:37 GMT

Hi,

If adding or removing an Excel feature creates and remove the error I suggest you open a support ticket and ask them to investigate if it is a bug.

Best Regards,

Ruggero

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

Re: NPrinting final report using excel filters

Lech_Miszkiewicz — Tue, 05 Jun 2018 12:20:03 GMT

did you follow all the steps from this topic - which i also mentioned above in my previous comments?

nprinting Excel with Pivot

There was similar issue and <deleterow> tag resolved it...

Re: NPrinting final report using excel filters

eleni_theodorid — Thu, 07 Jun 2018 10:45:23 GMT

Hi Lech,

Yes, I have tried it as well with no luck.

It seems like there are some issues with formats because when I am trying to open the excel file it gives me that error "We found a problem with some content in 'Pivot.xls'. Do you want us to try to recover as much as we can? If you trust the source of this workbook click Yes. ". When I click Yes it opens with zero data in some columns.

Regards,

Eleni

Re: NPrinting final report using excel filters

Lech_Miszkiewicz — Fri, 08 Jun 2018 01:04:47 GMT

Is this happening when you run a preview in NPrinting?

Do you have any group or security policies applied on servers or more - on your computer ? It definitely looks like that...

Also what versions of Excel are you using and what specific version of NPrinting? Is ist April 2018?

regards

Lech

Re: NPrinting final report using excel filters

Ruggero_Piccoli — Fri, 08 Jun 2018 08:14:44 GMT

Hi,

First of all, please use latest stable version, April 2018, so you take advantage of all fixed bugs.

Try to create the final report in Excel by exporting data from QlikView and without involving Qlik NPrinting.

If you will have the same issues it means there is something bad with Excel and Qlik NPrinting is not the cause.

If working without Qlik NPrinting don't generate the issue I think you have to open a support ticket so we can investigate if there is a bug. In this case include the logs of the error, screenshots, the template etc to help the debugging process.

Best Regards,

Ruggero

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