Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I color my rows and columns on the pivot table?
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
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.