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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I change background color to a header in a Pivot Table, but only one column header

How can I change background color to a header in a Pivot Table, but only one column header?

1 Reply
Anonymous
Not applicable
Author

It depends what you're using as a "column" in you table. In pivot it can be dimension, or expression, or dimension value.
If it is a dimesion, and you have only one dimension - it is possible, otherwise probably not.
If it is an expression, and you have only one expression - it is possible, otherwise probably not.
If it is a value of a dimension, it is possible.

In the first two scenarios, you have to use "custom format cell" for your dimension or expression. See "help" how to use it.
in the case of value of dimension, you can use background color for the dimension, conditional on the value (e.g. if(Year=2011, lightgreen())