topic Text Value color based on Condition in Text object in QlikView

Text Value color based on Condition in Text object

Tue, 23 Apr 2013 09:37:44 GMT

Hi All,

Is there any way to change the text object value Color based on some condition?.

I have a text object below,

=' A Class:' & count({DIM_Type = {'A'} >}distinct Class_Key) &

' B Class:' & count({ DIM_STYPE = {'S'} >}distinct Class_Key)

And based on the below condition text colour has to change,

=if(Count(Remark)>=1 then Text object value should change to "Red" colour

Thanks,

Selva

Re: Text Value colur based on Condition in Text object

Anonymous — Tue, 23 Apr 2013 09:50:02 GMT

Hi Selva,

Under the Text Object Properties > Font tab> if you click the color icon you can use a calculated color condition to set the text color to an expression.

For example:

=If(5+5=10, lightred(), black())

Re: Text Value colur based on Condition in Text object

kaushiknsolanki — Tue, 23 Apr 2013 09:54:07 GMT

Hi,

yes you can do this.

Go to properties of textbox.

Click on the color

You will find the option "Calculated" Select that and paste your expression. like

if(count(Remark)>=1, Red())

Regards,

Kaushik Solanki

Re: Text Value colur based on Condition in Text object

Wed, 24 Apr 2013 11:31:41 GMT

Thanks Kaushik & Johannes.. It's Perfect..