topic Block Chart Caption doesn´t keeps dinamic color configuration! in QlikView

Block Chart Caption doesn´t keeps dinamic color configuration!

fernandotoledo — Wed, 24 Nov 2010 13:47:27 GMT

Hi everybody!

I´m trying to create a block chart with two dimensions and dinamic colors.

I tried to set the first dimension caption color dinamically (as an expression like if(this,rgb(...),rgb()) ).

But when I hit ok the chart resolves the expression, take the result as the same color for every dimension value and the epression disapears!

Looks like a bug to me, since the EXPRESSION panel is enabled. Didn´t work in QV9 nor QV10.

See the image to understand where the problem is.

Best regards

Fernando

Block Chart Caption doesn´t keeps dinamic color configuration!

Wed, 24 Nov 2010 14:35:48 GMT

Hi!

I have some problems with color too.

I solve it via variables.

In calculation dimension i put just variable(for example vColor), in other place i change it, for example on button click (if ( this, vColor = 'RGB(...)', vColor = 'RGB(...)')

Try that, in my case it works fine.

Block Chart Caption doesn´t keeps dinamic color configuration!

Anonymous — Wed, 24 Nov 2010 14:44:37 GMT

I've the same problem: I've a Bar chart with and expression "exp" I've setted up a colour expression for my expression like: "if(exp

Block Chart Caption doesn´t keeps dinamic color configuration!

Anonymous — Wed, 24 Nov 2010 14:47:56 GMT

I've the same problem: I've a Bar chart with and expression "exp" I've setted up a colour expression for my expression like: "if(exp<0,RED,GREEN)"

I'd like to have a chart with a bar green or red if the exp is >0 or <0...

Block Chart Caption doesn´t keeps dinamic color configuration!

fernandotoledo — Wed, 24 Nov 2010 14:48:28 GMT

The problem is that, even using variables, the expression is erased when closing the properties window. Strange, isn´t it?

Block Chart Caption doesn´t keeps dinamic color configuration!

Wed, 24 Nov 2010 15:14:58 GMT

Normal 0 false false false RU X-NONE X-NONE MicrosoftInternetExplorer4

That's my calculated color :

if(vDim03 like 'some exp.',$(vColorBtAct),$(vColorBtInact))

vDim03 - I change on some action, it doesn't matter. All works fine.

Can you write in what case color must change?

Block Chart Caption doesn´t keeps dinamic color configuration!

kji — Wed, 24 Nov 2010 15:22:47 GMT

The color for this is flagged internally as not calculable, which however is unfortunately not reflected in the UI. Furthermore, the only color settings that is evaluated on a per value basis in a chart is the Background Color and Text Color subexpressions.

Block Chart Caption doesn´t keeps dinamic color configuration!

Wed, 24 Nov 2010 15:55:27 GMT

Normal 0 false false false RU X-NONE X-NONE MicrosoftInternetExplorer4

Sorry, Johan, but i don't get it.

You say that color can't change dynamic by some action?

But I change color of caption, by some action.

My English is poor, so that I don't understand you can be not your fault, but can you explain one more time, what you mean on "not calculable"? : )

Block Chart Caption doesn´t keeps dinamic color configuration!

fernandotoledo — Wed, 24 Nov 2010 16:13:18 GMT

So, like Johan said, it seems to be "working as designed"