topic changing table box font color based on field value in QlikView

changing table box font color based on field value

sayadutt — Tue, 03 Jun 2014 15:51:40 GMT

Hi,

I have a table box which contains few columns like below:

column1 column2 column3

11 AA Completed

22 BB In progress

33 CC Not Applicable

Now i need to have the font colors based on value of column3.

for eg:

if column3 = Completed -> make the font of entire row green

if column3 = In Progress-> make the font of entire row blue

can you please help me to achieve this.

Thanks!!!

MayilVahanan — Tue, 03 Jun 2014 15:56:05 GMT

Try like this

There is no option in table box, use straight chart.

Edit:

Try with this exp: Pick(Match(column3, 'Completed','In Progress'), green(), blue())

Anonymous — Tue, 03 Jun 2014 18:40:41 GMT

And, repeat this for every dimension and expression.