Text Colour and Background colour in a Pivot Chart

[Anonymous]

Hi all,

sounds like stupid question but i just can't get the text colour or background colour to work in this instance...

I have been able to in other instances but here it's not working for me...

I have qlikview pivot chart, in which I have a dimension (ISHCQTYAvailable) which has been pre-calculated in the load script, this gives the quantity available for a particular product.

I want the text to be red if it's in the negative, and green if it's in the positive and black, if it's just 0.

So in "Text Colour" under that dimension I have the following:

=IF(ISHCQTYAvailable > 0, Green(),

     IF(ISHCQTYAvailable < 0, Red(), Black()))

why isn't this working for me - any ideas?

Thanks in advance everybody!!

Fab

[Anil_Babu_Samineni]

You can create dummy data and share same situation application so then we an offer you