topic Re: Nprinting HTML - How change background color based on the data from field or expression? in Qlik NPrinting

Nprinting HTML - How change background color based on the data from field or expression?

vitaliichupryna — Sat, 16 Nov 2024 02:53:15 GMT

Hello,
I'm working on the embedded HTML report. I built HTML table and add necessary styling, one problem is background color for rows in the report. Customers wants see different background based on data in the table. In Qliksense script I created condition that determine color, but I don't know how apply it correctly.

First I created formula with ColorCode as calculation but it breaks structure of my table if I have more than one row in table, so I can use this way only for header.

Then I added ColorCode field in my table and tried to use it as parameter for styling, but it doesn't work.

Is it possible to make background color dynamic?

Thanks,
Vitali

Re: Nprinting HTML - How change background color based on the data from field or expression?

Ruggero_Piccoli — Mon, 29 Jul 2019 13:40:21 GMT

Hi,

I suppose you cannot add the Qlik Sense table as an image.

Could you add some screenshot of the template and the HTML code you are using? I would to understand better and try to reproduce in my installation.

What version of Qlik NPrinting are you using?

Best Regards,

Ruggero

Re: Nprinting HTML - How change background color based on the data from field or expression?

vitaliichupryna — Tue, 30 Jul 2019 06:30:47 GMT

Hi,

Thank you for help.

Below you can see example of report and html code in attachment.

I use Nprinting November 2018.

Thanks,

Vitalii

Re: Nprinting HTML - How change background color based on the data from field or expression?

Lech_Miszkiewicz — Tue, 30 Jul 2019 07:27:46 GMT

have you inspected a result of you html? How is your colour values passed?

did you encode your HTML? in properties of the field you are trying to pass as html colour value (see screenshot)

Re: Nprinting HTML - How change background color based on the data from field or expression?

vitaliichupryna — Tue, 30 Jul 2019 07:56:10 GMT

Lech, thank you for solution

Re: Nprinting HTML - How change background color based on the data from field or expression?

Lech_Miszkiewicz — Tue, 30 Jul 2019 08:01:53 GMT

Does it work though? Did you test it?

Re: Nprinting HTML - How change background color based on the data from field or expression?

vitaliichupryna — Tue, 30 Jul 2019 10:57:18 GMT

Yes, it works as I need.

Thanks,

Vitalii