Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Beginner
New Contributor III

Custom Colors for Multiple Measures: Expression

Hi,

 

I have 4 measures in my bar chart, each for which I would like to assign a custom color.

 

What type of expression would I input in 'color by expression' to color each one individually with a RGB code? 

 

Note the measure is a sum and looks like this:

Sum([stream 1])

 

Thanks!

1 Solution

Accepted Solutions

Re: Custom Colors for Multiple Measures: Expression

I would not try to use "color by expression".  Instead, define each measure as Master Measure. The master measure dialog allows you to assign a color in the "Measure Color" option.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

5 Replies

Re: Custom Colors for Multiple Measures: Expression

I would not try to use "color by expression".  Instead, define each measure as Master Measure. The master measure dialog allows you to assign a color in the "Measure Color" option.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

satishkurra
Valued Contributor II

Re: Custom Colors for Multiple Measures: Expression

lwestmaas
New Contributor III

Re: Custom Colors for Multiple Measures: Expression

Hi Rob - we met at the Philadelphia Master's summit, hope all is well!

 

As far as I know I can't use an argb color code in master measures. Is that accurate? If so, I think that means you have to use Color By Expression if you want to use an argb. And I think that means using synthetic (valuelist) dimensions, which I'd really prefer to avoid. Is that the choice I'm facing or do you know another option?

 

Thanks!

Lucas

Highlighted

Re: Custom Colors for Multiple Measures: Expression

I don't think you can type an argb() expression, but you can use the hex version of the rgb code. 

2019-01-11_11-20-49.png

-Rob

lwestmaas
New Contributor III

Re: Custom Colors for Multiple Measures: Expression

That's what I've ended up doing on a few occasions, I just like the translucent affect of ARGB. Thanks!

Community Browser