Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Colored text in Table Box for an input field

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

7 Replies
sunil2288
Creator III
Creator III

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
Partner
Partner

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.

Not applicable
Author

Hi,

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

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
Creator III
Creator III

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..

Not applicable
Author

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

Not applicable
Author

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

View solution in original post

Not applicable
Author

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