topic Color a field in a table box in QlikView

Color a field in a table box

gfisch13 — Wed, 28 Jul 2021 18:34:35 GMT

Hi Folks, in the attached figure I'm showing a table box I created in one of my projects. This table contains matched data from two different systems. I would like to color the field called EXP_AMT so that it stands out and focuses my users eye. I cannot figure out how to color this field, and I'm open to just coloring the field header or the underlying data.

Thanks in advance for your help!

George

Re: Color a field in a table box

MayilVahanan — Thu, 29 Jul 2021 09:00:09 GMT

Instead of using table box, try with straight table and you can color it based on "text color" like below

Re: Color a field in a table box

gfisch13 — Thu, 29 Jul 2021 12:02:54 GMT

Hi, I've tried this as you suggested but I'm either not understanding the use of the straight table or I did something wrong. All of the fields I need had to be added as dimensions, and then I need to set an expression. I left the expression blank and now the straight table comes back as blank, while there is plenty of data in my table box object. I can see how to set the color as you describe but just not sure what happened to the data.

Thanks!!

Re: Color a field in a table box

MayilVahanan — Thu, 29 Jul 2021 15:24:32 GMT

If you want all the field as dimension, add expression as 1. And hide the expression in the presentation tab like below.

And add color in the dimension like below

Hope it helps

Re: Color a field in a table box

gfisch13 — Thu, 29 Jul 2021 17:09:36 GMT

Thank you - This method worked perfectly!!!