Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

gokulnath2592
New Contributor III

How to get larger tables into PDF output format in Nprinting.

Hi All,

I have a pivot table in my Qlikview reports which has 15 columns and more than 35 rows of data.

Since it is a pivot table not able to generate it in PixelPerfect and save it in PDF output format. On trying with PPTX and XLSX formats to generate the reports and save it as PDF output format we are losing some of the rows or columns. Not able to display the tables properly.

Thanks,

Gokul

5 Replies

Re: How to get larger tables into PDF output format in Nprinting.

How your recreating the Pivot table in NPritning ?? as a image or table ?? I would suggest you to use word or XLSX .

If you import the Pivot table as a image that would help you I guess

gokulnath2592
New Contributor III

Re: How to get larger tables into PDF output format in Nprinting.

Hi Avinash

Thanks for your reply. But the table size is huge. I have a total of 16 columns and 40 rows. On recreating it as image i get scroll bars.

On recreating it as Excel and saving it in PDF format half of the columns come in first page and the next half in the second page. Not able to get the table in a single page. How to resolve this formatting issue. Any ideas?

Thanks,

Gokul

sujeetsingh
Honored Contributor III

Re: How to get larger tables into PDF output format in Nprinting.

seems you need to accmodate your hardware.

Re: How to get larger tables into PDF output format in Nprinting.

Gokul, we cannot  increase  the page height rite. What is the problem if the data is shown in 2 sheets since we cannot fit the complete data in one slide is applying pagination in Excel . Imagine if your data gets increased to  100 rows then you cannot fit in 1 slide rite. I would suggest you to go with the current pagination approach.

Otherwise you need to adjust the chart size , test size then should try to fit in 1 slide

stig1984
Contributor

Re: How to get larger tables into PDF output format in Nprinting.

When you are importing the data into Excel in the NPrint designer have you tried setting the page width to 1 page instead of automatic?  This can be found under the page layout tab and will then apply a zoom to force the table to fit one page wide - if it's a huge table it may not be readable though.

Community Browser