Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multicolored in Combo chart

Dear Community,

For the combo charts, i want to show the bar chart in multicolor, it works fine when there is only one expression as shown below:

But when i add another expression, multicolored selection is gone, the bars turn to similar color. Anyone can help?

I cannot fix the color to every dimension because there might be thousand dimensions in the document...

Thanks and best regards,

Chanel

1 Solution

Accepted Solutions
Gysbert_Wassenaar

As you noticed the option Multicolored works only if there is one expression. There is a workaround:

Click on the + sign in front of the expression, select Background Color and add an expression to calculate the color for the bar. If you have a small number of dimension values (up to 20) you could use color(fieldindex('MyDim1',MyDim1)). Replace MyDim1 with the name of the dimension you use in your chart.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

As you noticed the option Multicolored works only if there is one expression. There is a workaround:

Click on the + sign in front of the expression, select Background Color and add an expression to calculate the color for the bar. If you have a small number of dimension values (up to 20) you could use color(fieldindex('MyDim1',MyDim1)). Replace MyDim1 with the name of the dimension you use in your chart.


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Wassenaar,

Thanks so much for your prompt response, currently my dimension has less than 20 values, but it will grow to more than 20 in the future.

Somehow, I did try your solution, it changed the bar color to black. Am I doing any wrong step?

Thanks and best regards,

Chanel

Gysbert_Wassenaar

You forgot the last part: Replace MyDim1 with the name of the dimension you use in your chart.


talk is cheap, supply exceeds demand
Not applicable
Author

Awesome man! You are really Legend!

Thanks and best regards,

Chanel

pandiarajan
Creator
Creator

Dear Gysber,

              Thank  u for ur idea.its really working fine. suppose my dimensions any cyclic group how it will work ? any idea Mulicolor combo chart with cyclic group