topic Re: Concat 2 Fields in QlikView

Concat 2 Fields

Mon, 01 Dec 2014 15:46:43 GMT

Hi guy,

I have to fields i want to concatenate in a list box. My problem is that Field1 &' '&Field2 generates another empty value (known bug in QV11). However can someone give me an example how to solve this problem with the concat() function? I don't get the concationation function working based on the syntax. I tried for example concat(Field1, Field2).

Many thanks,

Harry

Re: Concat 2 Fields

prieper — Mon, 01 Dec 2014 16:01:09 GMT

CONCAT can work only in aggregation, please check the Help-function.

The attached should do without blanks.

HTH Peter

Re: Concat 2 Fields

JonnyPoole — Mon, 01 Dec 2014 16:46:07 GMT

If the fields were 'Region' and 'Year', this expression will eliminate the blank value for Year:

= if ( mid( Region & ';' & Year, FindOneOf( Region & ';' & Year,';')) <> ';',Region & ';' & Year)

Re: Concat 2 Fields

Mon, 01 Dec 2014 21:42:02 GMT

Many thanks! I have tried the concat() and aggr() function and it worked.

However I'm searching a way to combine 2 variables into one variable.

But I think this is only possible in script. Please correct me if I'm wrong....

Many thanks,

Harry

Re: Concat 2 Fields

MarcoWedel — Mon, 01 Dec 2014 23:07:30 GMT

Should also be possible with trigger/action.

Re: Concat 2 Fields

Anonymous — Fri, 19 Dec 2014 16:10:53 GMT

@Harry_Lee Can you please post your script how u were able to use concat in an aggregated afunction. I can not use concat for some reasons