Dynamic table in NPrinting

[thamyribas]

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

[Anonymous · Accepted solution]

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

[thamyribas]

Thanks!

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

[Anonymous]

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.

[thamyribas]

Okay, but using Qlik Sense, does it work?

[Anonymous]

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

[thamyribas]

Thank you so much for you help!

im go to test!

=D