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

[vitaliichupryna]

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

[Ruggero_Piccoli]

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

[vitaliichupryna]

Hi, 

Thank you for help.

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

I use Nprinting November 2018.

Thanks,

Vitalii

[Lech_Miszkiewicz · Accepted solution]

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)

[vitaliichupryna]

Lech, thank you for solution

[Lech_Miszkiewicz]

Does it work though?  Did you test it?

[vitaliichupryna]

Yes, it works as I need.

Thanks,

Vitalii