topic Re: Color Coding in QlikView

Color Coding

hkg_qlik — Mon, 19 Nov 2012 17:01:01 GMT

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,

Re: Color Coding

Clever_Anjos — Mon, 19 Nov 2012 17:06:45 GMT

Use "Background color" for the expression and implement

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

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

Re: Color Coding

hkg_qlik — Mon, 19 Nov 2012 17:48:59 GMT

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

Please the attached file.

Regards,

Re: Color Coding

Clever_Anjos — Mon, 19 Nov 2012 18:31:58 GMT

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

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

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

Re: Color Coding

its_anandrjs — Mon, 19 Nov 2012 18:40:59 GMT

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

Re: Color Coding

shree909 — Mon, 19 Nov 2012 18:44:59 GMT

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

Re: Color Coding

hkg_qlik — Mon, 19 Nov 2012 18:47:19 GMT

Not working.

Re: Color Coding

Clever_Anjos — Mon, 19 Nov 2012 18:55:08 GMT

Which QV version are you using?

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

Re: Color Coding

hkg_qlik — Mon, 19 Nov 2012 19:05:38 GMT

sure. I am using

Version: 11.00.11414.0 SR2

Thanks,

Re: Color Coding

rwunderlich — Mon, 19 Nov 2012 19:30:07 GMT

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

-Rob

Re: Color Coding

its_anandrjs — Mon, 19 Nov 2012 19:34:17 GMT

Hi,

Convert your Pivot table into Straight table. Then it works better.

Regards,

Anand

Re: Color Coding

Clever_Anjos — Mon, 19 Nov 2012 19:53:17 GMT

Just convert to straight table and mark every expression with "No Totals" and everything willbe fine

Re: Color Coding

hkg_qlik — Mon, 19 Nov 2012 20:00:20 GMT

Thanks.

Re: Color Coding

rwunderlich — Tue, 20 Nov 2012 04:57:30 GMT

By the way, this bug (51678) is fixed for pivot tables on SR2 update 1 released on 11/9.

-Rob