Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
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
I have now added qvw example.
the problem is the pibot date!
see atach.
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.
I will bump it, maybe someone else will propose other solution...
Hi Kuba,
Please find the attached file hope this will helps.
Regards,
Nirmal
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