Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this?
Hi,
i hope it will useful.
PFA
Sorry!! I did not get any attachment
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?
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);
Hi,
I have attached a sample.qvw file.