PixelPerfect Font Foreground Color Conditional on other Column

[QlikCommSa]

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!

[Lech_Miszkiewicz · Accepted solution]

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

[QlikCommSa]

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. 

[Lech_Miszkiewicz]

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

[Ruggero_Piccoli · Accepted solution]

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

[QlikCommSa]

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? 

[Ruggero_Piccoli]

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

[QlikCommSa]

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!

[Ruggero_Piccoli]

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