Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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())