Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Bar Chart Question

I am trying to create a multicolored bar chart which has 1 dimension and 1 expression, chart below.  The dimension results in 6 different bars which are sales territories and I need them all to have a unique color.  I don't want to have 6 different expressions, is there a way to use the color functions within the dimension? Regions.jpg

5 Replies

Re: Bar Chart Question

On the Expression click the + to its left and double click Background Color,

Here add simple expression like red() and all the bars will turn red.

Then you can add an if as in:

     if ( [YoruDim='Something' , red() , blue() )

From there you can nest if's until you get what you desire.

ecolomer
Honored Contributor II

Re: Bar Chart Question

You can use the option in label colour for MULTICOLOUR and select the colours in the list

jsaradhi
Valued Contributor

Re: Bar Chart Question

so are you unable to select multicolored in colors tab?

Untitled.png

Not applicable

Re: Bar Chart Question

Thank you guys for responding so quick!  I was able to figure it out with a combination of a couple of your comments.  The if statement needs to go in the "Background" format of the Expression.

Not applicable

Re: Bar Chart Question

I couldn't get the Milticolor box to become active.  In other Bar Charts I have that capability, the only difference between the two is the one I was originally trying to work off of is a Combo Chart.  Do you think that is the reason I can't choose the Multicolor option?