Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
3 Keynotes, 100+ Breakout Sessions, 1 New York Times bestseller, and you. QlikWorld Online, May 10-12: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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
Author

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

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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

http://c3js.org/

reddy-s
Master II
Master II

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.