Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

coloring the rows and columns on pivot

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

Tags (1)
2 Replies
New Contributor II

Re: coloring the rows and columns on pivot

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


Not applicable

Re: coloring the rows and columns on pivot

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.