topic Re: Problem with LET and Concat() in the script in QlikView

Problem with LET and Concat() in the script

jordicastilloga — Tue, 03 Jul 2018 13:05:32 GMT

Hi!

I have a problem when trying to assign a value to a variable in the script.

- I have to assign a list of values of an excel to one variable. For that, I load the excel, and then I put the following statement in the script:

LET variable1 = Concat(Field1,',').

The problem is, that, later on, variable1 is assigned with 'Concat(Field1,','), instead of the content of the Field1 (eg. 11,14,15,16).

How can I fix that?? I just want to assign the string '11,14,15,16' into the variable1.

Many thanks!!

Jordi.

Re: Problem with LET and Concat() in the script

neelamsaroha157 — Tue, 03 Jul 2018 15:51:41 GMT

If I understand your question correctly, instead of using the values from Field1 column, you want to hard code the strig '11, 14, 15, 16'.

If the above statement is correct then may be use can use Set instead of Let - SET variable1 = '11,14,15,16'.

Re: Problem with LET and Concat() in the script

jordicastilloga — Tue, 03 Jul 2018 18:17:43 GMT

Ni Neelam,

Thank you very much for your answer. I can't do that because the numbers will be stored in one excel and will be changed every week by the user. So I need to extract the numbers from the excel, and put it in one variable. There is any way??

Thanks!!!!!!

Re: Problem with LET and Concat() in the script

BalaBhaskar_Qlik — Wed, 04 Jul 2018 10:14:14 GMT

May be like this:

ABC:

LOAD * Inline

[

Field

5];

let noRows = NoOfRows('ABC')-1;

for i=0 to $(noRows)

let vVar=FieldValue('CaptureDateTime',$(i));

Temp:

LOAD * ,'$(vVar)' as Field1

Resident ABC;

next i

Drop table ABC;

Re: Problem with LET and Concat() in the script

thevingo — Wed, 04 Jul 2018 10:58:46 GMT

why do you want this to be done at script-level(Back end).

At the expression-level(Front end) i.e. in textbox it works fine

Re: Problem with LET and Concat() in the script

dapostolopoylos — Wed, 04 Jul 2018 11:14:27 GMT

Check out the attached app.

Re: Problem with LET and Concat() in the script

jordicastilloga — Thu, 05 Jul 2018 11:27:36 GMT

YEEEEEEEEEEEEEEAH!!!

Thanks Dimitrios!!!

Re: Problem with LET and Concat() in the script

dundigalla — Thu, 28 Feb 2019 16:51:06 GMT

Thank You Guru

Re: Problem with LET and Concat() in the script

danimartinroiback — Mon, 31 Mar 2025 16:15:11 GMT

Please, can you send the .qvs file? I want the script. Thanks.