topic Re: Dynamic table in NPrinting in Qlik NPrinting

Dynamic table in NPrinting

thamyribas — Tue, 02 May 2017 20:23:34 GMT

Good afternoon,

I need to report on NPrinting in PivotTable format, but NPrinting does not support this table format, would you like to know if someone has some form of formatting or some way to put a table in that format to generate Nprinting reports?

The data in the tables would be: in the first column the product names and in the following columns the days of the month for a daily control of each product sale.

Ex.:

Products 01/01/17 02/01/2017 03/01/2017

Banana 50 30 30

Apple 50 30 30

Guava 50 30 30

Re: Dynamic table in NPrinting

Anonymous — Tue, 02 May 2017 21:02:38 GMT

Have Nprinting only output the table of data with a level.

Then have the Excel pivot point to it.

See How to Create an Excel PivotTable Report

Re: Dynamic table in NPrinting

thamyribas — Tue, 02 May 2017 21:53:22 GMT

Thanks!

One question, The table used would be a normal table, not a pivot table?

Re: Dynamic table in NPrinting

Anonymous — Tue, 02 May 2017 21:58:38 GMT

Yes. Normal table in Qlikview to normal table/range in Excel by using Nprinting levels.

Then in the Excel template create a pivot table pointing at the data within the level.

The link I provided goes through it pretty well.

Re: Dynamic table in NPrinting

thamyribas — Tue, 02 May 2017 22:44:22 GMT

Okay, but using Qlik Sense, does it work?

Re: Dynamic table in NPrinting

Anonymous — Wed, 03 May 2017 14:16:25 GMT

You should be able to. QlikSense would require Nprinting 17.xx I believe.

These instructions indicate how to do it. I don't have QlikSense but according to this you should be able to.

https://help.qlik.com/en-US/nprinting/17.2/Content/ExcelReports/HowCreatePivotTableExcelTableColumns/Pivot-table-Excel.h…

Re: Dynamic table in NPrinting

thamyribas — Wed, 03 May 2017 14:32:46 GMT

Thank you so much for you help!

im go to test!