topic Re: How to qualify a String? in QlikView

How to qualify a String?

azimabadi — Wed, 11 Apr 2012 09:08:19 GMT

Hi all,

i have a string field, let's assume 'Name':

Name Age
----------------------

Tobias 20

Richard 23

i wnat to use the concatenated Names in FOR...EACH...NEXT control.

my code looks like :

LOAD concat( Name , ',' ) as conNames

FROM ......

LET ConNames = Peek( 'conNames' );

result is :

Tobias,Richard

but this doesn't work in FOR...EACH. i need something like:

'Tobias','Richard'

i tried :

LOAD concat( '''' & Name & '''' , ',' ) as conNames

but it doesn't work and i get error when runing script. i need a way to qualify the string value of Name with '.

Thank you all

How to qualify a String?

CELAMBARASAN — Wed, 11 Apr 2012 09:12:57 GMT

Hi,

Try using Chr() function like below

LOAD chr(39) & concat( Name , Chr(39)& ',' chr(39)) & chr(39) as conNames

FROM ......

Celambarasan

Re: How to qualify a String?

azimabadi — Wed, 11 Apr 2012 09:21:25 GMT

thank you so much for advise,

i think the answer is :

LOAD concat( chr(39) & Name & Chr(39) , ',' ) as conNames

Re: How to qualify a String?

CELAMBARASAN — Wed, 11 Apr 2012 09:29:18 GMT

Hi,

Yes.You can use like that also.

Celambarasan

Re: How to qualify a String?

Miguel_Angel_Baeyens — Wed, 11 Apr 2012 09:32:20 GMT

Hi,

Even when the expression editor does not recognize the Chr() after the comma as second parameter, is likewise valid, and the following expression should work in any object or variable:

LOAD Chr(39) & Concat(Name, Chr(39) & Chr(44) & Chr(39)) & Chr(39) AS conNames

conNames should store now something like

'Peter','Mike','Anthony'

Hope that helps.

Miguel