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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
shrutipg
Contributor II
Contributor II

different colors to the columns of same vizlib pivot table

Hi ,

I want to apply different header colors to the set of columns in same table. 

Table used here is a vizlib pivot table. 

 

I tried below code in the appearance > background color expression 

=if(match(GetObjectMeasure(10),NameOfTheMeasure),'#555555','#000000')

 

match function is returning 1 but above code is not working in appearances header color expression 

 

Can anyone please help me on below issue? 

1 Reply
NickAdams
Contributor
Contributor

This is dated, but posting this incase it helps someone else. We can use the Header Label (HTML) option within the measure dropdown. I use the below code to color my header orange. The issue I have with this is when I export the formatted data to excel, The HTML code is shown on the exported table.

='

<span style="background-color:#e05929;
width: 100%; padding: 1000px;

">ColumnName</div>