topic Re: Nprinting Pixel Perfect Report in Qlik NPrinting

Nprinting Pixel Perfect Report

Smeenakshi23 — Wed, 25 Sep 2019 18:40:54 GMT

Hell

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

Is there any release notes regarding it ???

Regards,

Soundarya

Re: Nprinting Pixel Perfect Report

Chanty4u — Mon, 07 Aug 2017 11:19:23 GMT

Hi,

Try here

Help needed on NPrinting 17 pixel perfect reports

NPrinting - Pixel perfect report

How to Create a Simple PixelPerfect Report

Re: Nprinting Pixel Perfect Report

Smeenakshi23 — Mon, 07 Aug 2017 11:25:01 GMT

Yes Thanks.

I have done with all these.. But i need to Have a pivot table structure as like in Qlikview.. Where the Pivot tables groups the values..

Re: Nprinting Pixel Perfect Report

Chanty4u — Mon, 07 Aug 2017 11:26:02 GMT

Hi,

For that you need to create a custom template to get the exact view.

Re: Nprinting Pixel Perfect Report

Smeenakshi23 — Mon, 07 Aug 2017 11:31:02 GMT

how to do That any idea ?? I am using nested levels. everything is perfect. But i want to display it as a pivot table.. where dimensions should not get repeated.. Instead same dimension has to grouped up

Re: Nprinting Pixel Perfect Report

samrat_g — Mon, 07 Aug 2017 11:33:25 GMT

Hi Soundarya,

Pivot Table is not supported in Nprinting.

But While Designing, You can do pivot table structure manually.

Re: Nprinting Pixel Perfect Report

Smeenakshi23 — Mon, 07 Aug 2017 11:42:52 GMT

Thanks a lot. So you mean like we can group up the values..as the below image (Table 2 ).. Here Blackout has been grouped up... is it possible

Re: Nprinting Pixel Perfect Report

Chanty4u — Mon, 07 Aug 2017 11:48:14 GMT

yes,

that is what you need to create in Excel as a custom template and you need to use the same in designer.

Re: Nprinting Pixel Perfect Report

samrat_g — Mon, 07 Aug 2017 11:48:54 GMT

Hi Soundarya,

May I know one question??

Why are you using Pixel Perfect Report and what is the output file format??

It can be done in Excel Report..

Re: Nprinting Pixel Perfect Report

Smeenakshi23 — Tue, 08 Aug 2017 06:41:29 GMT

My out put format would be Pdf. Since Nested level is not possible in Excel we suggest pixel perfect report.

Re: Nprinting Pixel Perfect Report

samrat_g — Tue, 08 Aug 2017 07:05:47 GMT

See The Images.

is your Requirement fulfill ?

The Data I've taken:

Output:

Re: Nprinting Pixel Perfect Report

Smeenakshi23 — Tue, 08 Aug 2017 07:26:20 GMT

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 ?

Re: Nprinting Pixel Perfect Report

samrat_g — Tue, 08 Aug 2017 08:10:11 GMT

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..

Re: Nprinting Pixel Perfect Report

Smeenakshi23 — Tue, 08 Aug 2017 09:29:08 GMT

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.

Re: Nprinting Pixel Perfect Report

Chanty4u — Tue, 08 Aug 2017 09:32:37 GMT

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

Re: Nprinting Pixel Perfect Report

Smeenakshi23 — Tue, 08 Aug 2017 09:56:52 GMT

Re: Nprinting Pixel Perfect Report

Chanty4u — Tue, 08 Aug 2017 10:05:46 GMT

Hi,

you can set the format in excel like below

Re: Nprinting Pixel Perfect Report

Smeenakshi23 — Tue, 08 Aug 2017 10:25:16 GMT

Yes I will check this option and get back .

Re: Nprinting Pixel Perfect Report

Ruggero_Piccoli — Tue, 08 Aug 2017 10:25:31 GMT

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.

Re: Nprinting Pixel Perfect Report

samrat_g — Tue, 08 Aug 2017 10:27:30 GMT

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".