topic Re: Straight Table - Text colour formatting affecting expression header in QlikView

Straight Table - Text colour formatting affecting expression header

Tue, 16 Jun 2015 13:42:51 GMT

Hi all

In a straight table I am using the following If statement to conditionally format the text of an expression.

If($(vBalanceAvailable)<0,$(vRedText))

vRedText = RGB(156,0,6)

On the Access Point, the expression header is also taking on the vRedText colour, whereas in the QlikView application the expression header remains as black text, which is what I want.

Please see attached screenshot. Is there a fix for this?

Thanks

James

Re: Straight Table - Text colour formatting affecting expression header

avinashelite — Tue, 16 Jun 2015 13:46:00 GMT

Hi James,

can you please share your app

Re: Straight Table - Text colour formatting affecting expression header

ecolomer — Tue, 16 Jun 2015 13:54:21 GMT

You can put this expression on the Style label for the expression and also you can activate in Preferences of user, the option

Re: Straight Table - Text colour formatting affecting expression header

stigchel — Tue, 16 Jun 2015 13:54:37 GMT

You can use this to skip the header

=if(Rowno()>0,If($(vBalanceAvailable)<0,$(vRedText)))

Re: Straight Table - Text colour formatting affecting expression header

ecolomer — Tue, 16 Jun 2015 13:56:43 GMT

and with right buton select option to change format on option personalise format

Re: Straight Table - Text colour formatting affecting expression header

paulovendruscol — Tue, 16 Jun 2015 14:09:09 GMT

hello,

It is quite likely that the color of text (title) of the tab (visual effects) is red. Switch to black.