Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
pkukkonen3
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

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

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.

Community Browser