topic Re: Backgroud Color of Straight Table values in QlikView

Backgroud Color of Straight Table values

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Backgroud Color of Straight Table values

sunny_talwar — Tue, 24 May 2016 18:05:32 GMT

Like this?

Re: Backgroud Color of Straight Table values

muthukumar77 — Tue, 24 May 2016 18:25:18 GMT

Hi,

i hope it will useful.

PFA

Re: Backgroud Color of Straight Table values

Tue, 24 May 2016 19:37:08 GMT

Sorry!! I did not get any attachment

Re: Backgroud Color of Straight Table values

Tue, 24 May 2016 19:44:33 GMT

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?

Re: Backgroud Color of Straight Table values

sunny_talwar — Tue, 24 May 2016 20:13:39 GMT

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);

Re: Backgroud Color of Straight Table values

muthukumar77 — Wed, 25 May 2016 07:19:25 GMT

Hi,

I have attached a sample.qvw file.