Select background color of an expression in bar chart via value list

[Anonymous]

Hi,

I am having a stacked bar chart with the following setup:

1 dimension as a value list: (=ValueList('A','B','C')

and a few expressions:

1) if(ValueList('A','B','C') = 'A', SUM({<Type={'Won'}>}SalesA), if(ValueList('A','B','C') = 'B', SUM({<Type={'Won'}>}SalesB), null()))

2) if(ValueList('A','B','C') = 'B', SUM({<Type={'Lost'}>}SalesA), if(ValueList('A','B','C') = 'B', SUM({<Type={'Lost'}>}SalesB), null()))

3) ...

For my second expression only (so the lost sales) I want now to change the color of the bar under certain circumstances but only for the value A from the value list.

.Under background color for expression 'B' I used a expression like:

if(ValueList('A','B','C') = 'B',

if("my specific condition", color1, color2))

This works fine if I comment out the first line of the expression (the value list pick) but then I obviously get the color change for all values in the list.

If I use the expression as stated above then the color will not change and always stay as color1.

So my question is now is it possible to change the background color of a bar in a chart by using a value list in the background color expression?

Thanks for your help.

Best regards

[Anonymous]

Scrambling doesnt really help my concerns. So I guess I will just have to find some expert within my company that might be able to help.

Anyway. Thank you for your help so far. It helped me at least to get a first step forward in the right dirrection.

[sunny_talwar]

All the best my friend .

Please close this thread by marking assumed answer.

Best,

Sunny