Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Color - Combo Chart with multiple bars in Qlik Sense - can I set certain Measure's bar color using an expression?

In a Qlik Sense combo chart, can I manually set the color of the bars representing a certain Measure using an expression?

Tags (4)
7 Replies
phaneendra_kunc
Valued Contributor III

Re: Color - Combo Chart with multiple bars in Qlik Sense - can I set certain Measure's bar color using an expression?

Yes. you can do that by turning off Auto Colors in Appearance.

and then choose by expression and add your expression.

8-28-2014 11-46-42 AM.jpg

Not applicable

Re: Color - Combo Chart with multiple bars in Qlik Sense - can I set certain Measure's bar color using an expression?

Thank you!

More specifically, how do I reference only one of the Combo Chart Measures in the expression? (or maybe - where can I find a reference to learn to write the expression to reference the Measure?)

Thanks,

Lanny

phaneendra_kunc
Valued Contributor III

Re: Color - Combo Chart with multiple bars in Qlik Sense - can I set certain Measure's bar color using an expression?

Refer Below.

Re: color by expression - QlikSense

Also i would suggest to view these tutorials.

New to Qlik Sense Videos

MVP
MVP

Re: Color - Combo Chart with multiple bars in Qlik Sense - can I set certain Measure's bar color using an expression?

Hi,

I think there is no such of right now in the current version, may in future release they will provide like in Qlikview

Expressin -> Background.

But for now you can change the based on the dimension value not by Expression.

You can change the colors by dimension value for example

If(Year=Year(Today()),Red(),Green()) in


Appearance -> Color -> Custom By Expression.


Hope this helps you.


Regards,

Jagan.

Highlighted
ses
Contributor

Re: Color - Combo Chart with multiple bars in Qlik Sense - can I set certain Measure's bar color using an expression?

Hi Lanny,

See my response in Re: color by expression - QlikSense

This may work for you.

harishicon
New Contributor III

Re: Color - Combo Chart with multiple bars in Qlik Sense - can I set certain Measure's bar color using an expression?

You can use color  but in term of condition only. Ex:- if(expression>0,Green(),Red())

or if(Year='xyz',Red()) like this.....

s_achraphe
New Contributor III

Re: Color - Combo Chart with multiple bars in Qlik Sense - can I set certain Measure's bar color using an expression?

Hello,

Another way is to create a master item of your specific measure and there you can set the color of it

then replace your measure by the master item

A.