topic Re: Background Color in Pivot table not always work. in QlikView

Background Color in Pivot table not always work.

Thu, 23 May 2013 09:02:49 GMT

Hello,

I have a pivot table and Color Code column there which background should be same as text in the field...

I have implemented it this way:

=IF(ColorCode='Green',RGB(171,255,199),

IF(ColorCode='Orange',RGB(255,231,132),

IF(ColorCode='Red',RGB(255,186,165),

IF(ColorCode='Blue',RGB(148,205,249),

RGB(255,255,255)

))))

But, strangely, there are fields which are not colored:

(attached image)

EDIT:

I have now added qvw file for better explanation.

Thanks for all advice!

Re: Background Color in Pivot table not always work.

fdelacal — Thu, 23 May 2013 09:11:21 GMT

add. TRIM,,, may be is that you have space

IF(TRIM(ColorCode)='Green',RGB(171,255,199),

IF(TRIM(ColorCode)='Orange',RGB(255,231,132),

IF(TRIM(ColorCode)='Red',RGB(255,186,165),

IF(TRIM(ColorCode)='Blue',RGB(148,205,249),

RGB(255,255,255)

))))

HOPE THAT SOLVE YOUR PROBLEM, if not, can you add a qvw. example?

Regards

Re: Background Color in Pivot table not always work.

Sokkorn — Thu, 23 May 2013 09:14:28 GMT

Hi Kuba,

Not sure you try this one yet

=IF(WildMatch(ColorCode,'*Green*'),RGB(171,255,199),

IF(WildMatch(ColorCode,'*Orange*'),RGB(255,231,132),

IF(WildMatch(ColorCode,'*Red*'),RGB(255,186,165),

IF(WildMatch(ColorCode,'*Blue*'),RGB(148,205,249),

RGB(255,255,255)

))))

Regards,

Sokkorn

Re: Background Color in Pivot table not always work.

Thu, 23 May 2013 09:19:02 GMT

Thank you both for fast reply, ColorCode has only 4 values so this is not (unfortunetly) connected to data mismatch.

I will try to prepare some qvw.

BR,

Kuba

Re: Background Color in Pivot table not always work.

Thu, 23 May 2013 10:07:11 GMT

I have now added qvw example.

Re: Background Color in Pivot table not always work.

fdelacal — Thu, 23 May 2013 10:18:43 GMT

the problem is the pibot date!

see atach.

Re: Background Color in Pivot table not always work.

Thu, 23 May 2013 10:22:30 GMT

I understnad that, but client wants to see it presented as in initial file... Is there any workaround for that?

This seems like a QV bug.

Re: Background Color in Pivot table not always work.

Tue, 04 Jun 2013 09:24:24 GMT

I will bump it, maybe someone else will propose other solution...

Re: Background Color in Pivot table not always work.

Tue, 04 Jun 2013 12:08:09 GMT

Hi Kuba,

Please find the attached file hope this will helps.

Regards,

Nirmal

Re: Background Color in Pivot table not always work.

Fri, 07 Jun 2013 12:21:04 GMT

Hello,

Thank you for reply but it deos not work. I must divide htis data by date, So when I will move date it is still not working properly...

Attaching your file with change I need.

BR,

Kuba