Discussion board where members can get started with Qlik Sense.
I have strange a requirement to colour stacked bar chart. I have to colour dimension values (col A in red, col B in blue and col C in Green) and rest of the dimension values (col D to H ) should be coloured with default colours. Is this possible?
I think not possible
I am afraid that's not possible.
what you want to do is possible. It is just a little bit complicated. You wil have to set colors for all columns (it is not possible to set only three and let the rest "default")
Do you use only one measure (like sum(sales)) and it is split by dimension (col A)?
If so, than go to Apperance->colors and Legend, set colors to custom and select by expression.
Than set it like this
If(<your dimension>='col A',RGB(170,255,106),
If(<your dimension>='col B',RGB(85,232,216),
If(<your dimension>='col C',RGB(232,192,85),
If(<your dimension>='col D',RGB(124,116,255),
If(<your dimension>='col E',RGB(255,123,99),
If(<your dimension>='col F',RGB(153,129,96),
If(<your dimension>='col G',RGB(204,127,27),
If(<your dimension>='col H',RGB(27,204,72)))))))))
Of course use your own RGB value (or if you like it you can use this ) You should get something like this
You can refer https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Colors/color-by-expression.htm
In Stacked Bar chart - Add Dimensions, measures.
Appearance - Colors & Legend - By dimension.
For Expression wise color apply:
Use below expression, tweak your main expression.
Check this too:
How to custom color a stacked bar chart
Thanks guys for your suggestions. I got to know this is not possible.