Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Background Color in Pivot table not always work.

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!

9 Replies
fdelacal
Specialist
Specialist

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

Sokkorn
Master
Master

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

Not applicable
Author

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

Not applicable
Author

I have now added qvw example.

fdelacal
Specialist
Specialist

the problem is the pibot date!

see atach.

Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

Hi Kuba,

Please find the attached file hope this will helps.

Regards,

Nirmal

Not applicable
Author

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