Skip to main content
Announcements
April 9th: The AI Roadmap: 6 Landmarks for AI-ready Data and Analytics: 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

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

Anonymous
Not applicable
Author

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

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

http://c3js.org/

reddy-s
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.