topic Re: Function Concat in dimension in QlikView

Function Concat in dimension

suzel404 — Wed, 28 May 2014 11:02:51 GMT

Hi all

How can I obtain values not in line:

Example : Concat(DISTINCT Name&' '&LastName&' '&PostaleCode, chr(10)

I want :

Name LastName PostaCode

Name LastName PostCode

NameLastName PostalCode

Thank you for your help.

Re: Function Concat in dimension

Wed, 28 May 2014 11:08:24 GMT

Why dont you just try a calculated dimension:

=Name&' '&LastName&' '&PostaleCode

or you use a straigt table with the 3 dimensions and then you have everything right next to each other.

regards,

Re: Function Concat in dimension

Anonymous — Wed, 28 May 2014 11:11:28 GMT

Try this:

Name & ''& LastName & '' & PostaCode

Re: Function Concat in dimension

tresB — Wed, 28 May 2014 11:13:57 GMT

Try:

=Concat(DISTINCT Name&' '&LastName&' '&PostaleCode )

Re: Function Concat in dimension

Wed, 28 May 2014 11:22:32 GMT

why yould you need a concat for this??

Re: Function Concat in dimension

tresB — Wed, 28 May 2014 11:28:06 GMT

Concat() would be required to handle a lot of records. That is, if you want this to work in place like text box/variable; with such scope where there would be more than one records - this aggregation function would be required. Hope this clarifies.

Re: Re: Function Concat in dimension

suzel404 — Wed, 28 May 2014 12:30:24 GMT

Thank but I woulf like the previous range and forward range in dimension.
I can obtain it in expression But not in dimension.

How can obtain it in dimension.

Re: Function Concat in dimension

suzel404 — Wed, 28 May 2014 12:38:13 GMT

I use valueList (StartEnd).

Thank.