How to create a pixel perfect table limited to 10 rows

[Richard3]

I need to create a table in pixel perfect that will show me only 10 records out of all the ones that exist in my data.

[David_Friend]

@Richard3 good morning! Please do us a favor and label your post with ONLY the version of NPrinting you are using, also the version of QlikView or QlikSense.

Also do you want the 10 rows to be top 10 rows? Or just random?

[Ruggero_Piccoli · Accepted solution]

Hi,

At the link https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlik-nprinting-documents/7/1/PixelPerfe... you can download a tutorial in PDF that explains many solutions in PixelPerfect including the one you requested. It uses PixelPerfect scripting that must be enabled and the ability to customize the C# code. There is not a native feature to select a number of rows to be displayed in a PixelPerfect table. 

Another solution could be limit the rows in a native Qlik Sense straight table and use it to create the level behind the PixelPerfect table. 

Based on the list of labels you added this solution will work with: NPrinting 16.0, NPrinting 16.1, NPrinting 16.2, NPrinting 16.3, NPrinting 16.4, NPrinting 16.5, NPrinting 16.6, NPrinting 16.7, NPrinting 16.8, NPrinting 16.9, Qlik NPrinting, Qlik NPrinting 17.0, Qlik NPrinting 17.1, Qlik NPrinting 17.2, Qlik NPrinting 17.3, Qlik NPrinting June 2017, Qlik NPrinting May 2021, Qlik NPrinting May 2021 SR1, Qlik NPrinting May 2021 SR4

If you are still using one or more of NPrinting 16.0, NPrinting 16.1, NPrinting 16.2, NPrinting 16.3, NPrinting 16.4, NPrinting 16.5, NPrinting 16.6, NPrinting 16.7, NPrinting 16.8, NPrinting 16.9 please plan a migration to a supported version as soon as possible.

If you are using one or more of  Qlik NPrinting 17.0, Qlik NPrinting 17.1, Qlik NPrinting 17.2, Qlik NPrinting 17.3, Qlik NPrinting June 2017, they are out of support so please plan an upgrade as soon as possible to a supported version

Best Regards,

Ruggero

[Richard3]

Despite the fact that the explanation is very good, it does not do anything for me in my version, I am using Qlik NPrinting September 2020 and the script does not work for me, it simply does nothing. Do you have any idea what it could be?

[Ruggero_Piccoli]

Hi,

So please:

• clean the long list of labels in the first post
• add the only version you use that is missing 
• September 2020 is no more supported so I suggest that you plan an upgrade. Read the documentation in the help site and in the release notes before starting the upgrade procedure.

Thanks.

PixelPerfect scripting must be enabled otherwise they are not executed for security reason:

For more details refer to: https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/AdministeringQVNprinting/Admin-setti...

If you don't want to enable PixelPerfect scripting you can create a straight table with the rows you need in the source app. 

Best Regards,

Ruggero

[Frank_S]

Nice @Ruggero_Piccoli !

New article containing this wonderful PDF.

https://community.qlik.com/t5/Official-Support-Articles/PixelPerfect-Advanced-Reporting-Tutorial-Doc...