Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.