topic Re: Set multiline variable in QlikView

Set multiline variable

Wed, 25 Nov 2020 16:16:04 GMT

I have a variable splitted as multiline:

SET varList = "One", "Two", "Three",

"Four", "Five", "Six";

Is it the best way to do it?

Re: Set multiline variable

phaneendra_kunc — Fri, 05 Aug 2016 22:02:44 GMT

Any reason you want this to split into multiple lines.

Above works fine, but if you place this variable in text box it wont be centered perfectly. or you can try below to center perfectly.

let varList = '"One", "Two", "Three",'&chr(10)&'"Four", "Five", "Six"';

Re: Set multiline variable

Fri, 05 Aug 2016 22:07:49 GMT

I need to split into multiple lines because the line is too long.

Re: Set multiline variable

phaneendra_kunc — Sat, 06 Aug 2016 08:30:46 GMT

Ok. Both expressions will work. you can use your SET or LET statement that i have provided.

Re: Set multiline variable

Sat, 06 Aug 2016 17:01:46 GMT

I use this variable to contain the columns to be loaded from an excel. If I use chr(10) then it cause some weird behaviour in my table, first rows inserted contains the header columns, so I solve it by replacing chr(10) and chr(13) from the string variable as below:

LET varList = REPLACE(REPLACE(varList,CHAR(10),''),CHAR(13),''))