topic Re: Qlikview Pivot table in Nprinting in Qlik NPrinting

Qlikview Pivot table in Nprinting

Wed, 18 Mar 2015 17:36:27 GMT

Hi Friends,

recently I am using Nprinting tool to export QV reports into excel,But I am not able to export QV pivot chart into excel with its pivoting format,I tried all the steps mentioned on the Nprint tutorial site. If anyone has any idea to resolve this issue kindly share with me.It is very urgent requirement.

Regards

Bhawna

Re: Qlikview Pivot table in Nprinting

Daniel_Jenkins — Thu, 19 Mar 2015 01:59:38 GMT

Hi Bhawna,

You can use NPrinting to recreate a QlikView pivot table in Excel very easily. Please follow this tutorial: http://community.vizubi.com/knowledgebase/articles/261214-how-to-create-an-excel-pivottable-report

Feel free to contact Support if you need further assistance.

Best,

Daniel.

Re: Qlikview Pivot table in Nprinting

Thu, 19 Mar 2015 15:01:21 GMT

hey Daniel,

I have tried the way tutorial said,but I dont want to recreate the pivot table in excel,because If I do I am not able to add my set analysis or condition which I applied in my QV pivot chart I want to add as it into excel as in QV pivot chart,can you help me in this.

regards

Bhawna

Re: Qlikview Pivot table in Nprinting

Daniel_Jenkins — Sun, 29 Mar 2015 00:03:12 GMT

Hi Bhawna,

I'm not sure what you mean by adding set analysis or conditions in an Excel chart. If you add the PivotTable chart into the NPrinting Excel report template, your resultant report will contain a straight table. You will get a similar result if you use the QlikView 'Send to Excel' option. Currently, the only way to create an Excel pivot table is to build it in the report template. You can then leverage the myriad Excel formatting options. You can use the steps in the link I sent earlier or in this one: http://community.vizubi.com/knowledgebase/articles/261211-how-to-create-a-pivot-table-from-excel-table-colum

Hope this helps.

Re: Qlikview Pivot table in Nprinting

mohsinqlik — Mon, 15 Jun 2015 12:27:44 GMT

NPrinting does not allow columns wise formatting on qlikview pivot table.Formatting works on entire table instead of each columns.You can work around by creating levels and cloning and converting pivot table to straight table.

If you can elaborate your problem maybe i can help you more.

Regards,

Mohsin Choudhary

Re: Qlikview Pivot table in Nprinting

anuradhaa — Mon, 02 Nov 2015 14:37:07 GMT

Can you please share the example. I also having problems in creating PDF using qlikview pivot table in nprinting. I can create HTML,EXCEl but not pdf

Re: Qlikview Pivot table in Nprinting

Tue, 03 Nov 2015 15:56:03 GMT

Nprinting does not really support pivot tables as true pivots directly from Qlikview to Excel - they are exported to Nprinting the same way as if you exported the pivot to Excel (that is due to the Qlik function that is called - it is the same one when exporting to Excel).

If you bring in the table as a pivot table, it is treated by Nprinting basically as an image - you cannot format any rows or cells and the appearance is slightly differernt than how ti looks in QlikView.

Since you cannot foramt the table, one option that I have used, especially if the table does not take more than a page, is to bring the pivot table in as an image.

If it needs to be a true pivot in Excel, I agree with Daniedl, that it has to be brought into Nprinting as a straight table and converted in the tempalte to a pivot

Re: Qlikview Pivot table in Nprinting

mohsinqlik — Wed, 04 Nov 2015 10:22:58 GMT

Can you share your example QVW file.

Regards

Mohsin

Re: Qlikview Pivot table in Nprinting

Mon, 09 Nov 2015 13:58:16 GMT

Bhawna

any update or progress on this?

Re: Qlikview Pivot table in Nprinting

Tue, 15 Dec 2015 00:19:16 GMT

Hi,

Can you share the document. That link is broken.

Thankyou !!

Re: Qlikview Pivot table in Nprinting

Stephen_Jasionowski — Tue, 15 Dec 2015 01:36:55 GMT

All of the NPrinting tutorials moved from the Vizubi website to the Qlik Community Resource Library. Here is an indexing of the tutorials by subject: QlikView NPrinting Tutorials by Subject

As for the pivot tables, here are the 2 options that Daniel refers to:

How to Create a Pivot Table from Excel Table Columns

How to Create an Excel PivotTable Report