Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Smeenakshi23
Creator II
Creator II

Nprinting Pixel Perfect Report

Hell

Is it possible to have a pivot table in Nprtinting Pixel Perfect Report ??

Is there any release notes regarding it ???

Regards,

Soundarya

25 Replies
samrat_g
Partner - Contributor III
Partner - Contributor III

See The Images.

is your Requirement fulfill ?

The Data I've taken:

data.png

Output:

output.png

Smeenakshi23
Creator II
Creator II
Author

Exactly the same !! I wann implement this in Pixel perfect report ???

2 ) Also in Excel template , PDF format report can we eliminate the lines for each row ?

samrat_g
Partner - Contributor III
Partner - Contributor III

No, in Pixel Perfect Report, this can't done.

I didn't get you "PDF format report can we eliminate the lines for each row ?"


Can you explain..

Smeenakshi23
Creator II
Creator II
Author

if I preview the Excel report as pdf template,I could see the lines for each Row.. I dont want to have the lines.. Also could u pls let me know how u have customized pivot table.

excel.JPG

Chanty4u
MVP
MVP

you can hide the pivot table column   select column/row right clik hide and preview in designer

Smeenakshi23
Creator II
Creator II
Author

excel.JPG

Chanty4u
MVP
MVP

Hi,

you can set the format in excel  like below

line.PNG

Smeenakshi23
Creator II
Creator II
Author

Yes I will check this option and get back .

Ruggero_Piccoli
Support
Support

Excel pivot table are supported in Qlik NPrinting Excel reports Creating pivot table using Excel table columns ‒ Qlik NPrinting. An Excel report can be exported in PDF format, but you don't have the same fine control as a PixelPerfect report.

If you need a PDF it means that you don't need to give access to the data at the final recipient, so you could evaluate to add the original QlikView pivot table as an image inside the template.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
samrat_g
Partner - Contributor III
Partner - Contributor III

you can't use pivot table.

first you have to change the chart from pivot table to straight table.

After that when you add table object in Nprinting, uncheck "Keep Source Format".