Concatenation of Filed with text.

[infosense_devel]

Hello,

i have scenario where i have to concatenate filed with some text.

i have "region" a filed and i am trying like below,

=REGION&' (Including Consumer)'

this is working fine but this is generating  one more extra line as below.

thanks in advance.

[rwunderlich]

Modify your expression like this:

=if(len(REGION) > 0, REGION & ' (Including Consumer)')

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[sunny_talwar]

May be try this

=If(Len(Trim(REGION)) > 0, REGION & ' (Including Consumer)')