Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Sense - Combo Chart - colors by expression

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.

Capture.PNG

thank you for your support!

Jernej

6 Replies
jolivares
Valued Contributor

Re: Qlik Sense - Combo Chart - colors by expression

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

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

Not applicable

Re: Qlik Sense - Combo Chart - colors by expression

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

balrajahlawat
Esteemed Contributor

Re: Qlik Sense - Combo Chart - colors by expression

Not applicable

Re: Qlik Sense - Combo Chart - colors by expression

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
Valued Contributor III

Re: Qlik Sense - Combo Chart - colors by expression

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

http://c3js.org/

reddys310
Honored Contributor II

Re: Qlik Sense - Combo Chart - colors by expression

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.

Community Browser