topic Re: Multicolored in Combo chart in QlikView

Multicolored in Combo chart

Sat, 05 Oct 2013 04:22:11 GMT

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

Re: Multicolored in Combo chart

Gysbert_Wassenaar — Sat, 05 Oct 2013 07:21:24 GMT

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.

Re: Multicolored in Combo chart

Sat, 05 Oct 2013 08:33:39 GMT

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

Re: Multicolored in Combo chart

Gysbert_Wassenaar — Sat, 05 Oct 2013 08:35:14 GMT

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

Re: Multicolored in Combo chart

Sat, 05 Oct 2013 08:39:16 GMT

Awesome man! You are really Legend!

Thanks and best regards,

Chanel

Re: Multicolored in Combo chart

pandiarajan — Thu, 19 Dec 2013 05:12:35 GMT

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