Discussion board where members can get started with Qlik Sense.
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
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.