Dimension Textcolour change in the Chart

Thu, 01 Sep 2011 12:02:35 GMT

Hi Guys,

My Aim is to get the Transaction colour same if the SAPRole Name is same.

I have this chart and I am trying to change the colour of Transaction based on SAPRoleName

SAPRole Name is Label for the field [Text role_RTEXT]

So I am trying in the Dimension Transaction-> Textcolour

and giving the following Expression

= IF([Text role_RTEXT] = above([Text role_RTEXT]), LIGHTBLUE(), LIGHTGREEN())

It shows the same colour as in the above diagram.

Any idea how to get different colours?

Thanks
Sravan

topic Dimension Textcolour change in the Chart in QlikView