topic Re: NPrinting - Pivot table headers in excel template in Qlik NPrinting

NPrinting - Pivot table headers in excel template

Anonymous — Tue, 20 Oct 2015 10:40:29 GMT

Hi,

I have the following pivot table in a QlikView document (this is an example):

I need to generate daily reports in pdf to send it by mail. I'm using an excel template Nprinting as follows (very simple):

The result to be generated PDF is as follows:

The headers are not combined and need to stay together. Can I use VBA script in Excel template to force the cell formatting? I tried in a trigger but not working...

There any way to do this kind of reports?

Thanks,

Re: NPrinting - Pivot table headers in excel template

yujiyamane — Wed, 21 Oct 2015 04:21:44 GMT

Have you tried to import the object as image? It should work for pdf.

Re: NPrinting - Pivot table headers in excel template

Anonymous — Wed, 21 Oct 2015 08:01:03 GMT

Hi,

It works if the graphic occupies as much a page but does not work if the graph occupies 2 or more pages....

Re: NPrinting - Pivot table headers in excel template

Wed, 21 Oct 2015 17:58:00 GMT

The issue you may run into is the way QlikView exports pivot tables. An option if you want a true pivot table in NPrinting is to make a copy of your pivot table as a straight table in QlikView and bring the straight table version into NPrinting - there are steps you can follow (see link below) where you can convert the straight table to a pivot and do formatting, etc.

How to Create a Pivot Table from Excel Table Columns – Customer Feedback for Vizubi

If the table is brought into nprinting as a pivot table, you have no control or formatting options like a straight table (and have less, if that is possible, when you bring in as an image)

Re: NPrinting - Pivot table headers in excel template

yujiyamane — Wed, 21 Oct 2015 21:48:02 GMT

I see what you mean. Maybe you can think about Macro if you export it as Excel. (The macro runs when user opens the excel file). But I am not sure about PDF export....