topic Re: PixelPerfect Font Foreground Color Conditional on other Column in Qlik NPrinting

PixelPerfect Font Foreground Color Conditional on other Column

QlikCommSa — Fri, 15 Nov 2024 22:55:43 GMT

Hi all,

I'm new to the Template Editor of NPrinting. I have following table in my QikSense App:

Article	Department	Price
Apple	Fruits	3,00
Tomato	Vegetable	2,00
Orange	Fruits	4,00

In my PixelPerfect PDF I want to create a table where all Articles and Prices are listed. The Article should be written red if it's a fruit.

I guess the answer how to solve this problem is really easy, but I haven't found out yet 😞

Thanks a lot in advance!

Re: PixelPerfect Font Foreground Color Conditional on other Column

Lech_Miszkiewicz — Wed, 05 May 2021 07:31:19 GMT

Hi,

you are using very advanced report template (pixel perfect) and you seem quite new to NPrinting so you are diving deep without experience.

There is too much to talk about so I just point you to the video which does exactly what you need. The concept is the same...

https://www.youtube.com/watch?v=CEXDTVKSoos

Re: PixelPerfect Font Foreground Color Conditional on other Column

QlikCommSa — Wed, 05 May 2021 08:00:07 GMT

Hi!

Thanks for your quick answer! I already found that option of formatting the text. But if I use

Iif([Department]='Fruits',True,False)

as condition for the Article field it doesn't work.

I want to format a field with a condition referring to another field. In your example, the condition referres to the same field.

Re: PixelPerfect Font Foreground Color Conditional on other Column

Lech_Miszkiewicz — Wed, 05 May 2021 08:26:44 GMT

That does not matter as long as that field is existing in the pixel perfect table...

Re: PixelPerfect Font Foreground Color Conditional on other Column

Ruggero_Piccoli — Wed, 05 May 2021 09:36:44 GMT

Hi,

You can use conditional formatting as I think you are trying to do. I attach a tutorial about it. The field you use to create the condition must be one of the filed in the table you are using in the level to create the native PixelPerfect table. Yes, sometimes you have to test and change to find the correct formula.

Please remember to add the label with the correct version of Qlik NPrinting you are using. Also some screenshots of the template could help.

Best Regards,

Ruggero

Re: PixelPerfect Font Foreground Color Conditional on other Column

QlikCommSa — Wed, 05 May 2021 11:44:37 GMT

Ok, if I add the column Department to the output table, the formatting works. But is there a way to not show the Department column? Can columns be hidden?

Re: PixelPerfect Font Foreground Color Conditional on other Column

Ruggero_Piccoli — Wed, 05 May 2021 12:28:35 GMT

Hi,

The column Department need to be one of the columns of the table you added in the level you used to create the details band. It is not needed to have that column in the table. I did some test on my installation with a table that uses a formatting rule on a field and it worked.

Best Regards,

Ruggero

Re: PixelPerfect Font Foreground Color Conditional on other Column

QlikCommSa — Wed, 05 May 2021 13:06:59 GMT

Unfortunately this is not working for me 😞 Can you send me your test?

I added the column now in the printed table and have a moderately satisfying result now.

Thanks a lot for all of your help!

Re: PixelPerfect Font Foreground Color Conditional on other Column

Ruggero_Piccoli — Thu, 06 May 2021 08:58:52 GMT

Hi,

Sorry for my delay. I used the resulting PixelPerfect report template from this tutorial https://community.qlik.com/t5/Qlik-NPrinting-Documents/PixelPerfect-Tutorial-pdf/ta-p/1495435

The formatting rule uses the field in the red rectangle so I applied it to the two fields in the green rectangle:

I deleted the red one from the template:

This is the result of the preview:

I wrote all details about how I created the formula etc in the tutorial linked at the beginning.

I hope this helps.

Best Regards,

Ruggero