Changing bar colour when using a calculated dimension

[#1]

Hi guys,

I've created a bar chart using a calculated dimension (which has 6, custom-made bars).

I want to change the colour of SOME of these bars, and not others. How do I do this?

For instance, I'd like

Calculated Bar 1 - Red

Calculated Bar 1 - Blue

Calculated Bar 1 - Blue

Calculated Bar 1 - Red

Thanks!

[#2]

Hi O G,

do you have 6 expressions in this chart?

regards

Darek

[#3]

Hi,

I have one expression, which is simply a count of the variable I have sorted based on the custom dimension.

As an example, the custom dimension seperates values in to groups of values, i.e. 1-50, 51-100, 101-200 etc.

[#4]

Hello,

find my example.

You can use conditional expression in backgroud color (under your expression).

regards

Darek

[#5]

Hi Dariusz,

Thanks for your responce, however this does not seem to be working.

I'm grouping the dimension as discussed above, so the dataset looks something like this:

1

20

38

19

2

39

49

28

etc...

Then i'm grouping these using a calculated dimension to 1-50, 51-100, 101-200 categories, and THEN counting how many of each there are, so the bar chart has the three categories above, with a count for each as the expression.

I want to be able to change the colour of the '1-50' only.

Any ideas? Unable to post a QVW as working with sensitive data. Thanks.

[#6]

Get color expression from my example and change condition. It should work. If not - prepare qvd with few rows or you may scramble your sensitive data.

regards

Darek

[jsingh71]

Share your sample qvw file.

[maleksafa]

in your dimension tab, under used dimensions, you can expand the dimension that you want and then go to background color and there you can use the built in color functions or use the RGB function to put your color.