topic Conditional Formatting in NPrinting HTML Report in Qlik NPrinting

Conditional Formatting in NPrinting HTML Report

shaunsomai — Fri, 30 Oct 2020 08:58:16 GMT

Hi All

I am using Qlik NPrinting June 2020 SR1 Version: 20.19.5.0

I have built an HTML report, now i want to add some conditional formatting to certain columns in the report.

Col 1,Col 2...Col 10 so

if values in Col 3 > 50% make background colour green else leave default

the screen shot shows typical formatting needed

Re: Conditional Formatting in NPrinting HTML Report

tm_burgers — Fri, 30 Oct 2020 14:18:03 GMT

Unfortunately you cannot use HTML to evaluate the values and then do any conditional formatting. You could use Keep Source Formatting with HTML, and then do the formatting in Qlik; with levels and some custom HTML you likely could reproduce what you have above.. or something similar.

But, I would recommend that you switch over to an Excel Template, and then use levels and excel conditional formatting to achieve your result.

Re: Conditional Formatting in NPrinting HTML Report

Lech_Miszkiewicz — Sun, 01 Nov 2020 04:53:29 GMT

Hi, I disagree.. you definitely can achieve it in HTML. You need to use Qlik Sense to also calculate colour for each column and row and return colour in the format you need in your html then use it as mentioned in this topic:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-HTML-How-change-background-color-based-on-the-data/td-p/1606963