Qlik Sense - Combo Chart - colors by expression

[#1]

hello fellow Qlik Sense people

I have a combo chart (bar + line) and would like to have colors by expression for both the bars and the line.

When the colors setting is on Auto it's blue (bars) + gray for others (top 10 selected) and red (line) which is good, but I would like a different shade of blue and red.

I know, I have to select Colors --> Custom and By expression, but I don't know, how to write the expression.

thank you for your support!

Jernej

[jolivares]

assuming that you want to put a different color for the bigger one

If(Sum(Sales)=Max(Aggr(Sum(Sales),Customer)), Blue(),Green())

[#3]

hi Juan

thank you for your answer. Unfortunately it's not what I was thinking. What I would like to do is color all the bars (except for the last one, which can stay as it is) with rgb(0,94,184) - blue and the line with rgb(188,32,75) - red. The reason is that these are our official colors...

Thank you.

Jernej

[Anonymous]

might be helpful for you?

https://community.qlik.com/thread/130571

Qlik Sense: How to set custom colors by measure in a bar chart

[#5]

thanks for the links. In one of the comments, I found this link:

Combo chart seperate colours by expression

and the answer is NO, it can't be done

[simondachstr]

You should consider building an extension object using the below library:

http://c3js.org/

[reddy-s]

Hi Jernej,

You will have to go with an extension to achieve this. This functionality is not available in the combo chart implicitly.

Thanks,

Sangram.