Color Coding

[hkg_qlik]

Hi,

I have built a Pivot table. Its regarding various ongoing projects with phase information:

I want to color code the fields itself inside the pivot table.

	1, No Issues
	2, Some Issues
	3, Critical Issues

Regards,

H

[Clever_Anjos]

Use "Background color" for the expression and implement

IF(column(1) = 'No issues',green(),

   IF(column(1) = 'Some Issues',yellor(),red())

[hkg_qlik]

Its working but it also fills in the background color for the column name.

Please the attached file.

Regards,

H

[Clever_Anjos]

IF(column(1) = 'No issues',green(),

   IF(column(1) = 'Some Issues',yellor(),

      IF(column(1) = 'Critical Issues',red(),null()))

[its_anandrjs]

Hi,

Write a script like

IF(column(1) = 'No issues', Green( ),

IF(column(1) = 'Some Issues', Yellow( ),

IF(column(1) = 'Critical Issues', Red( ), RGB(255,255,255,0) ) )

HTH

Regards,

Anand

[shree909]

Hi

write the expression for the text color then only the text color changes .

u find these options when u expand the + sign and select text folor

or else goto  the properties of the chart and select custom formatiing .

then u will find the oprions of doing  Bold and changing the background color.

either way it works...

[hkg_qlik]

Not working.

[Clever_Anjos]

Which QV version are you using?

Please, post your qvw here, I´ll do for you

[hkg_qlik]

sure. I am using

Version: 11.00.11414.0 SR2

Thanks,

H

[rwunderlich]

The background color bleeding to the heading is a known problem with pivot tables. Change to a sttraigt table as a workaround.

-Rob