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

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
Anonymous
Not applicable
Author

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
Master II
Master II

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

Anonymous
Not applicable
Author

so are you unable to select multicolored in colors tab?

Untitled.png

Not applicable
Author

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
Author

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?