topic Re: Concatenation and Highlight the record. in QlikView

Concatenation and Highlight the record.

Wed, 17 Aug 2011 14:07:32 GMT

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.

Re: Concatenation and Highlight the record.

Wed, 17 Aug 2011 15:14:14 GMT

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.

Re: Concatenation and Highlight the record.

Wed, 17 Aug 2011 19:03:16 GMT

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

Re: Concatenation and Highlight the record.

Thu, 18 Aug 2011 06:32:39 GMT

Sorry for bothering..

I have done it successfully.

Thanks a ton.