Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Text Value color based on Condition in Text object

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

3 Replies
jsn
Honored Contributor

Re: Text Value colur based on Condition in Text object

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

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

Not applicable

Re: Text Value colur based on Condition in Text object

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

Community Browser