Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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
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.
That does not matter as long as that field is existing in the pixel perfect table...
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
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?
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
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!
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