Backgroud Color of Straight Table values

[#1]

Hi

I am attaching a sample excel file. Sheet 1 has all ratings for 3 individuals and sheet 2 has current rating. I want all data(Sheet1) to be displayed in a straight table. Sheet 2 has current data. I want sheet 2 data to be highlighted in red

Thanks for your help

[sunny_talwar]

Like this?

[muthukumar77]

Hi,

i hope it will useful.

PFA

[#4]

Sorry!! I did not get any attachment

[#5]

Thanks, for the quick response Sunny!! The same data I have in 2 tables, Excel was only a sample application. It exactly does it in Excel. Now in the table I have joined 2 tables based on the name. If Rating Name and Rating is same in table 1 and table 2 i need to highlight.

Is it got to do something with Replace command?

[sunny_talwar]

Replace is just used to fill the missing data in Name column. Do you have Name on each of row or not. If not you can try this with another database:

Table:

LOAD If(Len(Trim(Name)) > 0, Name, Peek('Name')) as Name,

    [Rating Name],

    Rating

FROM

[..\Box Sync\QlikView\Community\bgcolor.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1);

Join (Table)

LOAD If(Len(Trim(Name)) > 0, Name, Peek('Name')) as Name,

    [Rating Name],

    Rating,

    'Current' as Flag

FROM

[..\Box Sync\QlikView\Community\bgcolor.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet2);

[muthukumar77]

Hi,

I have attached a sample.qvw file.