topic Re: Concat Values from Inline in a Variable in QlikView

Solved

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Solved

Re: Concat Values from Inline in a Variable

Gabriel — Mon, 16 May 2016 15:48:09 GMT

Hi,

You can use Concat function in your variable. The content of your variable is

Concat(Chr(39) & Amount & Chr(39),',') //Chr(39) is Single Quote

Re: Concat Values from Inline in a Variable

rubenmarin — Mon, 16 May 2016 15:48:51 GMT

Hi, you can try with this script:

Table:
LOAD * Inline [
FieldA
50
55
60
AB
CD
EF
];

Temp:
NoConcatenate LOAD Chr(39) & Concat(FieldA, Chr(39)& ',' & Chr(39)) & Chr(39) as FieldB
Resident Table; //We create the value to the variable in a field

LET vTable= FieldValue('FieldB', 1); //Assign the field value
DROP table Temp;

Re: Concat Values from Inline in a Variable

Kushal_Chawda — Mon, 16 May 2016 15:57:12 GMT

Data:
LOAD * Inline [
Field
50
55
60
AB
CD
EF
];

Field:
NoConcatenate
LOAD Concat(DISTINCT Chr(39)& Field & Chr(39),',' ) as NewField
Resident Data;

let vTable = Peek('NewField',0,'Field');

Re: Concat Values from Inline in a Variable

trdandamudi — Mon, 16 May 2016 16:02:05 GMT

You can create the variable in Variable overview.See attached screen shot: