topic Re: Concatenate a string to variable and use it as a field in QlikView

Concatenate a string to variable and use it as a field

saumyashah90 — Mon, 06 May 2013 07:13:23 GMT

Suppose i have 1 ,2,3,4,5 values comming out of variable "$(vPrevWeek)" and i want in field as Wk1,Wk2,Wk3,etc

I that means I want to concatenate string 'Wk' with $(VPrevWeek) and output of this iwant as Wk1,Wk2 which i want to use as field.How to do it?

Sokkorn — Mon, 06 May 2013 07:15:41 GMT

Hi Saumya,

Not sure you try this yet:

'Wk' & $(vPrevWeek) As [Weeks]

Regards,

Sokkorn

Mon, 06 May 2013 07:16:24 GMT

table1:

load * inline [

value

];

load

'wk' & value as value_new

resident table1;