Concatenation and Highlight the record.

[#1]

Greetings,

I am using Qlikview 10 personal edition.

My first query is.

I have to highlight the whole set of record.

like orgname, orgid, address, tel. I have to highlight at record level.

2. there is two fields in my txt file I need to concate it.

[#2]

actually when u r clicking on a field it will populate whole set of records I want to show the null fields as highlighted.

I guess I have to use like if(isNull(rowno()), yellow()).

But not getting where to use it exactly.

[#3 · Accepted solution]

You will want to adjust the background color for either the expression or the dimension. Click on the plus sign next to the expression and select the 'Background Color' option. Then put in an expression like:

if(isnull(address),red(),white())

This will highlight any null address field red while the rest remain white.

To concatenate two fields just do: Field1&' - '&Field2

[#4]

Sorry for bothering..

I have done it successfully.

Thanks a ton.