topic AW:Re: Colored text in Table Box for an input field in QlikView

Colored text in Table Box for an input field

Thu, 08 Jul 2010 09:36:57 GMT

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

Colored text in Table Box for an input field

sunil2288 — Thu, 08 Jul 2010 11:13:08 GMT

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

AW:Re: Colored text in Table Box for an input field

brenner_martina — Thu, 08 Jul 2010 11:43:24 GMT

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.

AW:Re: Colored text in Table Box for an input field

Fri, 09 Jul 2010 08:03:36 GMT

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

AW:Re: Colored text in Table Box for an input field

sunil2288 — Mon, 12 Jul 2010 09:05:49 GMT

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

AW:Re: Colored text in Table Box for an input field

Mon, 12 Jul 2010 09:49:41 GMT

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

AW:Re: Colored text in Table Box for an input field

Mon, 12 Jul 2010 11:06:55 GMT

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

AW:Re: Colored text in Table Box for an input field

Mon, 12 Jul 2010 12:37:00 GMT

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