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

[sanil_barik]

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!

[robert_mika · Accepted solution]

Try use Dimensionality()

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

[mrsimon007]

“In Qlik Sense, set the header styling in the table properties → Appearance → Presentation → Header, instead of using column formatting. That way only header rows get the theme color, not the first column.”