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: 
neerajthakur
Creator III
Creator III

Showing Top N Values from a Table in PixelPerfect

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.

 
 
Thanks & Regards,
Please Accepts as Solution if it solves your query.
Labels (2)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

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



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.

View solution in original post

2 Replies
Ruggero_Piccoli
Support
Support

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



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.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

1st topic:

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

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

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.