topic Re: Nprinting- HTML- missing color format in a table in Qlik NPrinting

Nprinting- HTML- missing color format in a table

Rado — Wed, 30 Nov 2022 14:03:50 GMT

Hi guys,
I need to Nprint table from QS into the email as HTML.
It can not be the image.

Table in QS has color formatting.
However when I put the object into the Nprinting as HTML, it is showing without color formatting.

Please can you advise how to fix it?

I have checked the box in Keep source formatting:

There are not other options in properties.

It should be like this e.g.:

However generate it w/o color. Also alignment is not very nice/readable:

Thank you in advance for help.

Re: Nprinting- HTML- missing color format in a table

Frank_S — Wed, 30 Nov 2022 19:38:11 GMT

If your Qlik Sense table is a pivot table, please note that this is not supported.

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Qlik-objects-supported-NP.htm#pivot

Also formatting in an HTML object might be problematic and complex so you might want to try exporting as an image instead rather than the data pivot table.

Or you can try using a straight table instead of the pivot table.

Colors will be exported as well if you use a straight table. But again, formatting columns and the data therein is going to require some strong HTML skills.

Kind regards...

Re: Nprinting- HTML- missing color format in a table

Lech_Miszkiewicz — Wed, 30 Nov 2022 22:21:45 GMT

You can add additional columns with colour codes to your source table in Qlik Sense and use HTML inline styles to colour code background.

This is easy and was described here: https://community.qlik.com/t5/Qlik-NPrinting/Nprinting-HTML-How-change-background-color-based-on-the-data/td-p/1606963

Re: Nprinting- HTML- missing color format in a table

Rado — Mon, 05 Dec 2022 09:39:18 GMT

Thank you guys for your advice.

It was affected by table format as Pivot table as you mentioned. For simple table it works.
In the end I exported it as image. Although the picture quality is not so good...
Maybe better HTML skills should help as you mentioned.

But seems this should be applicable. Will see the user feedback

Thank you both 🙂

Rado