Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

thamyribas
New Contributor II

Dynamic table in NPrinting

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

Tags (1)
1 Solution

Accepted Solutions
atkinsow
Valued Contributor II

Re: Dynamic table in NPrinting

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

6 Replies
atkinsow
Valued Contributor II

Re: Dynamic table in NPrinting

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
New Contributor II

Re: Dynamic table in NPrinting

Thanks!

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

atkinsow
Valued Contributor II

Re: Dynamic table in NPrinting

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
New Contributor II

Re: Dynamic table in NPrinting

Okay, but using Qlik Sense, does it work?

atkinsow
Valued Contributor II

Re: Dynamic table in NPrinting

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
New Contributor II

Re: Dynamic table in NPrinting

Thank you so much for you help!

im go to test!

=D

Community Browser