Colored text in Table Box for an input field

[#1]

I have a Table Box that is used to update association between teams, organizations and disciplines. When a new discipline is created the fields Team and Organization gets the default value "New Discipline". Both Team and Organization fields are defined as input fields in the script.

I would like to change the color of the text or the background when the fields get the value "New Discipline", so that when it happens it would be easier to identify. I cannot use a chart because I need to be able to change the value of the Team and/or Organization from "New Discipline" to its new value.

Is there any way to do this?

Thank you in advance,

/Yolanda

[sunil2288]

hi

You can Change the color by writing an expression that when the condition is true the text box become the specified color you have given..you can find the R,G,B Value from the color seting of caption

[brenner_martina]

Hi,

pardon, but this is only possible for the title, not for the background or text color in the table box! Both you have only in a chart.

[#4]

Hi,

Thank you for your comments, but my problem is still unsolved

As Martina pointed out, it is not possible to work in a table box as one does in a chart. That's my problem! Once again, I cannot present the table as a chart because I want to be able to edit the values of the input fields. But, how can I make them visible?

I appreciate your help!

/Yolanda

[sunil2288]

Hi Yperdomo,

In the table box Properties--->General tab,below there is a calculation condition for each field.

u can make it visible by writing condition there. Hope it will helpful..

Thanks

Suneel..

[#6]

Hi Suneel,

Unfortunately, that doesn't work. The calculation condition applies for the whole table, independently of the field. I already tried, before I posted my question, and QlikView doesn't like it: it crashes quietly and closes up, without even given a warning.

Thank you anyway,

/Yolanda

[#7 · Accepted solution]

Hi Yolanda!

How about using a straight table and a table box? See attached sample file.. I think its not the very appropriate solution to your problem, but I think the "idea" will somehow help you solve your problem.

- Lester

[#8]

Hi Lester,

Thank you for you idea, it was very inspirational. What I did was to create the chart table and put it behind so only a field with a colored box appears beside the "New Discipline" values on the table box that will be edited. It is not what I though at the begining, but it works!

/Yolanda