topic Conditional row colouring in HTML Reporting in Move to Qlik Cloud Analytics

Conditional row colouring in HTML Reporting

Aditya_Chitale — Tue, 27 Jan 2026 10:45:26 GMT

Hello All,

With the HTML template feature out for SaaS reporting, I was exploring some possibilities which I implemented in my on-premise Nprinting html report. One of which was conditional row colouring in which I created a column in Qlik Sense table that contained color code expressions based on certain criteria.

I then passed this column as an inline style attribute for background color for the column on which I wanted the conditional color to be applied. Here I made sure that 'HTML encode' option is checked for the derived column containing color codes.

I tried to replicated the same scenario in SaaS environment but was unable to do so. Is there any alternate way to achieve this ?

In above example the cell colors green, red and blue are passed as hexcode values calculated in a new column in qliksense for inline style bgcolor attribute for the column weekly returns in Nprinting template

@Lech_Miszkiewicz

Regards,

Aditya

Re: Conditional row colouring in HTML Reporting

Lech_Miszkiewicz — Wed, 25 Jun 2025 10:20:12 GMT

Hi @Aditya_Chitale

I am seeing this as the biggest missing component and I already voiced to @Andrew_Kruger that this gap needs to be filled.

As for now-i don know the workaround for this missing feature.

Re: Conditional row colouring in HTML Reporting

Aditya_Chitale — Thu, 26 Jun 2025 11:36:51 GMT

Hi @Lech_Miszkiewicz ,

Thanks for the reply. I tried to achieve this using automation method. but only got so far with the table creation method. I am still unable to conditional color the row.

In HTML reporting though, if you keep source formatting on for the table, the rows are coloured but any other formatting such as borders, etc get overridden.

Do you by any chance know if this is achievable through automation or not ?

Regards,

Aditya

Re: Conditional row colouring in HTML Reporting

Lech_Miszkiewicz — Thu, 26 Jun 2025 12:14:16 GMT

Hi @Aditya_Chitale

No i dont - I did spend some time using automations before but I have given up. Frankly I feel bit deflated by this. I am reading through the documentation about the HTML designer in SaaS and I see that there are plenty other restrictions as well which were not there in NPrinting (like those: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/html-report-allowed-code.htm) so really at this stage I need to evaluate if any of the reports I have in HTML would be suitable for migration at all given the requirements.

I have opened the Idea you can vote on (and maybe ask others to vote as well) so we can get the "HTML encode" feature back. https://ideation.qlik.com/app/#/case/494814?currentProductId=9da99bc1-0dfb-4471-8e12-d23685578c43&products=Qlik%20Community&groups=23564&cpid=300e4eec-cd72-4351-b6cb-cf81b94ae737(HTML Encode option available for in app HTML Reporting) although I am afraid that it will be denied as you could sneak in using that methof bit of code which is not allowed and gets removed in designer tool.

Anyway - lets see how it goes.

Re: Conditional row colouring in HTML Reporting

Aditya_Chitale — Thu, 26 Jun 2025 12:20:38 GMT

@Lech_Miszkiewicz

Again thanks for the input !! I noticed that too. Some part of code gets removed due to Qlik's code sanitation functionality.

Regards,

Aditya

Re: Conditional row colouring in HTML Reporting

Aditya_Chitale — Sun, 29 Jun 2025 12:01:50 GMT

Ok So after further digging, I was able to achieve required html report format using automation.

Firstly, drag a "Get straight table data block" in automation and configure it to use required table from qlik saas application

In automation, I used a "variable block" in which I appended color code values to the variable (lets say vColor) using a simple if() statement functionality provided in the "Add Operations" part of the block.

The erased part in red from above screenshot is the column which will contain the distinguishing value to color the entire table row. I then passed this value in circled blue part of the condition. If there are multiple values to be checked for highlighting multiple rows, you can append the values in the same variable. Here make sure to choose append rather than using set as this will override previous value of the variable

Once done with the color variable configuration part, you will need to create an additional variable (lets say vData) which will contain all the columns from "Get straight table data block". Here you can pass the color variable created and configured from previous variable block in the style tag of table html code.

Finally in the mail block, add above created variable (vData) to the body of your mail and run the automation.

Final Output:

My Final Automation structure looks something like this. I have used additiona variable vColorText. But we can ignore that for now.

Regards,

Aditya

Re: Conditional row colouring in HTML Reporting

mattnunninsideinfo — Sun, 30 Nov 2025 07:12:22 GMT

@Aditya_Chitale and @Lech_Miszkiewicz ,

I have found a method that works to conditionally format the text in an HTML Template table. It uses the the <style> tag in the html header to set the classes and then dynamically set the CSS class in the table.

I have attached the HTML template I used - Matt HTML.zip.

The important parts of the code are highlighted:

The table in the app contains a column called RAG and there is a small 'hack' I needed to get it to work.

Note the extra space is required after the class names.

The RAG field in the HTML template must also have the 'Keep Source Formats' unchecked.

Here is the HTML Report Preview:

Regards,

Matt

Re: Conditional row colouring in HTML Reporting

Aditya_Chitale — Sun, 30 Nov 2025 11:39:16 GMT

@mattnunninsideinfo , Will surely try your solution. could you explain the reason behind keeping blank space after the class names ?

Regards,

Aditya

Re: Conditional row colouring in HTML Reporting

mattnunninsideinfo — Sun, 30 Nov 2025 22:21:30 GMT

@Aditya_Chitale : The reason for the blank space is that Qlik always adds the characters '</TD>' to the class column. The space seems to allow the style to apply, as without it, it doesn't.

Re: Conditional row colouring in HTML Reporting

mattnunninsideinfo — Mon, 01 Dec 2025 21:57:05 GMT

Hi @Aditya_Chitale and @Lech_Miszkiewicz,

Unfortunately, I have hit an issue with this method. In the new Outlook client, the reading pane does not show the html formatting and just blank text. If I open up the email it works fine. Here is a what it looks like:

The only solution I can see now is if Qlik provides the option to not HTML encode columns like we have in NPrinting.