Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have Nprinting only output the table of data with a level.
Then have the Excel pivot point to it.
Have Nprinting only output the table of data with a level.
Then have the Excel pivot point to it.
Thanks!
One question, The table used would be a normal table, not a pivot table?
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.
Okay, but using Qlik Sense, does it work?
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.
Thank you so much for you help!
im go to test!
=D