topic Re: Bar Chart Question in QlikView

Bar Chart Question

Tue, 23 Dec 2014 18:49:00 GMT

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?

Re: Bar Chart Question

Anonymous — Tue, 23 Dec 2014 18:59:54 GMT

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.

Re: Bar Chart Question

ecolomer — Tue, 23 Dec 2014 19:23:23 GMT

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

Re: Bar Chart Question

Anonymous — Tue, 23 Dec 2014 19:30:18 GMT

so are you unable to select multicolored in colors tab?

Re: Bar Chart Question

Tue, 23 Dec 2014 19:36:54 GMT

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.

Re: Bar Chart Question

Tue, 23 Dec 2014 19:59:14 GMT

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?