Pixel perfect and conditional formatting report PDF

alexandernatale — Fri, 19 Jul 2024 18:52:14 GMT

Hi everyone,

I'm dealing with a request from management. My goal is to create a pixel perfect PDF report so that in the last column showing the totals, this is colored according to a color gradient from green to red.
The table shows the first 30 products ordered from most consumed to least consumed. The last column measures the deviation with respect to price and quantity changes (management control).

On the QS app I solved it easily like this:

Colormix1( Rank(r_Overall_effect_variance, 0, 1) / 30, RGB(255, 0, 0), // Red for lowest value RGB(0, 255, 0) // Green for the highest value )

How can I do it the same way on pixel perfect?

within the formatting rules there is neither the color mix function nor the Rank function.

Thanks!

Re: Pixel perfect and conditional formatting report PDF

Lech_Miszkiewicz — Mon, 22 Jul 2024 00:10:47 GMT

Hi.

First make sure you are providing us correct information:

according to your post you are on NPrinting 16.1
NPrinting 16.1 never supported Qlik Sense so that will never work
NPrinting 16.1 is long time not supported

Regarding conditional formatting in Pixel Perfect.

you will not be able to use colormix!
you will need to create as many ranges of conditional values as many gradients you want in your report. This will be difficult as you dont know the actual values you may have in the report so for this to work you would have to equalize it to 0-100% so you can operate within percentages rather than absolute values
- https://www.youtube.com/watch?v=CEXDTVKSoos
- https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-November-2019-Pixel-Perfect-Conditional-Formatting/td-p/1670215

Lastly I would probably build it based on excel template with PDF output (which effectively is a print of excel to PDF) and use excel conditional formatting as it would be so much easier:

cheers

topic Pixel perfect and conditional formatting report PDF in Qlik NPrinting

Pixel perfect and conditional formatting report PDF

Re: Pixel perfect and conditional formatting report PDF