topic Re: Showing Top N Values from a Table in PixelPerfect in Qlik NPrinting

Showing Top N Values from a Table in PixelPerfect

neerajthakur — Wed, 06 Oct 2021 04:56:04 GMT

Hi,

How can I show top 10 / N Values from a table in QlikSense into Pixel Perfect Report.

Another query is I am getting only top one row with the following table, how can I correct this issue.

Re: Showing Top N Values from a Table in PixelPerfect

Ruggero_Piccoli — Wed, 06 Oct 2021 07:48:22 GMT

Hi,

The simplest way, and the one I suggest, is to create a straight table in the source Qlik Sense app that shows only the Top N Values that you want to display in the generated report. Than you have to refresh the connection cache, close and reopen the Designer and use that table to create the native PixelPerfect table.

Another way is explained around page 31 of the pdf tutorial attached to https://community.qlik.com/t5/Qlik-NPrinting-Documents/PixelPerfect-Tutorial-pdf/ta-p/1495435. This requires scripting so you must enable it as explained in https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/AdministeringQVNprinting/Admin-settings.htm#anchor-6 but this will open a security issue and, if copying and pasting the sample C# is not enough, you will need the help of a developer.

Best Regards,

Ruggero

Re: Showing Top N Values from a Table in PixelPerfect

Lech_Miszkiewicz — Wed, 06 Oct 2021 07:49:07 GMT

1st topic:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Pixel-Perfect-Table-Sales-by-top-X/td-p/1277764

2nd topicL

I guess you are just not building it right (probably adding as a table and not as a level as it is required). For how to build PixelPerfect tables please refer to official help tutorials here:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/PixelPerfectReports/Add-Totals-Subtotals.htm

and step by step video here: https://www.youtube.com/watch?v=z-VprSroEW0&list=PLkRFvjyuHFvJuEyClP_K7G-_5RxoRH59w&index=7