Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sanil_barik
Partner - Contributor
Partner - Contributor

How to apply theme color only to header rows(not entire first column) in Qlik Sense table?

Hi All,

I am struggling with a table formatting issue in Qlik Sense and need your guidance.

As you can see in the attached screenshot, I want the theme color to be applied only to the header rows (for example: Booking Pipeline and Actual), but currently, the formatting is also being applied to the entire first column(Vehicle column values).

What I need:

  • Theme color should appear only in the first two header rows.

  • The rest of the first column(Vehicle names like ALTURAS, BE6, BOLERO, etc.) should remain without the theme color.

What I already tried:

  • Cell formatting using measure and dimension background color expressions

  • Different pivot table settings

Unfortunately, all these approaches ended up coloring the entire column, not just the first two rows.

My Question:
Is there any way in native Qlik Sense to restrict styling only to specific header rows without affecting the entire column?

Any suggestions, workarounds, or examples would be a huge help.

Thanks in advance!

Labels (3)
1 Reply
robert_mika
Master III
Master III

Try use Dimensionality()

=IF(Dimensionality() = 0, yourcolor  '')