Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

coloring the rows and columns on pivot

How do I color my rows and columns on the pivot table?

2 Replies
Anonymous
Not applicable
Author

Under each dimension or measure there is Background colour expression, which does that.

For example this expression changes cells in which Pareto-class is 'C'  to and so on

If([Pareto Class] = 'C', LightRed(), If([Pareto Class] = 'B', lightblue(), Green()))

Also, check this out. Works with Pivot-table too

https://help.qlik.com/en-US/sense/2.2/Subsystems/Hub/Content/Colors/color-by-expression.htm

Not applicable
Author

I can't find how to change the color of a Dimension, there is indeed a option for changing the color for a VALUE, but not for dimension.

In my case i want to change the color to red when the Dimension is named "Atrasado" for example... But i simply can`t access any Expression Changes for color on dimensions.

How can I do that? I`m sorry for posting here, but i thing we have like the same questions.