BG Color

[subbareddykm]

Hi all,

i m trying to achieve for color coding for my expression using my three fields value, i tried a lot but no luck.

can any one tell me how to achieve this.

Note : In Green, Yellow and Red those values may change in future. i want to make it dynamic.

Thankq in adv.

[nagarjuna_kotha · Accepted solution]

Hi,

I worked with your data and found some work around it.

check it out whether it matches your requirement. !

Script:

Final:

LOAD *,

if(Green_Flag=0,Right(Green_Range,2),Green_Range) as G,

if(Yellow_Flag=0,Right(Yellow_Range,2),Yellow_Range) as Y,

if(Red_Flag=0,Right(Red_Range,2),Red_Range) as R;

LOAD*,

If(WildMatch(Green_Range,'*.*'),1,0) as Green_Flag,

If(WildMatch(Yellow_Range,'*.*'),1,0) as Yellow_Flag,

If(WildMatch(Red_Range,'*.*'),1,0) as Red_Flag;

Data:

LOAD KPI,

     [Metric Unit],

     Goal,

     Green,

     If(Len(KeepChar(Green,'.0123456789'))>3,Left(KeepChar(Green,'.0123456789'),4),KeepChar(Green,'.0123456789')) as Green_Range,

     If(Len(KeepChar(Yellow,'.0123456789'))>3,Left(KeepChar(Yellow,'.0123456789'),4),KeepChar(Yellow,'.0123456789')) as Yellow_Range,

     If(Len(KeepChar(Red,'.0123456789'))>3,Left(KeepChar(Red,'.0123456789'),4),KeepChar(Red,'.0123456789')) as Red_Range,

     Yellow,

     Red,

     [Sum(Week_Actuals)] as Val

FROM

(biff, embedded labels, table is Sheet1$);

-Nagarjun