Custom color by measure...

[markp201]

My dimension is rstate and I have two expressions using set analysis

sum({$<region={South}>}sales)  //States in the south region

sum({$<region={North}>}sales)  //States in the north region

I have the following for the color

Colors and legends - Custom color - by expression

=IF(region='South',RGB(141,170,203),RGB(252,115,98))

All bars are red and I think I understand is the expression being checked is the dimension value

This is easy in Qlikview with the backcolor for expression but in Qlik sense - not so much.  Hoping there is a non-extension work around.

BTW - I would prefer not to add region as a dimension

Thanks

[Quy_Nguyen · Accepted solution]

You can add your 2 measures in master item, then choose the color for it. In the chart, let the color Auto