Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
1st topic:
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:
and step by step video here: https://www.youtube.com/watch?v=z-VprSroEW0&list=PLkRFvjyuHFvJuEyClP_K7G-_5RxoRH59w&index=7