topic Re: Variable as string in script in QlikView

Variable as string in script

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

I have a variable in my script as follows:

Set vAcadyear = 2016-17;

I then use this in several other places in my script (mostly in file names) which works just fine.

FROM

[$(vAcadyear)\Misc\Map.xls]

(biff, embedded labels, table is Points$);

Becomes

FROM

[2016-17\Misc\Map.xls]

(biff, embedded labels, table is Points$);

which is exactly what I want.

However, in another place in the LOAD statement I have:

LOAD

$(vAcadyear) as Year,

And that's not working as I want. In this case, it evaluates the variable, and gives me '1999' as 'Year' (i.e. 2016 minus 17!)

How do I get it to store this variable as a string, even though it "looks" like a calculation.

Thanks,
Jess

Re: Variable as string in script

Anonymous — Wed, 10 May 2017 08:29:25 GMT

Hi!

Sorry, I dont understand:

LOAD

$(vAcadyear) as Year

Do you mean that you use the value 2016-17?

Is it possible to have the script or a sample app?

Re: Variable as string in script

jessica_webb — Wed, 10 May 2017 08:31:25 GMT

Yes, I would now expect the field 'year' to have the value '2016-17'

At the moment, it gives me the value '1999' which is wrong.

Re: Variable as string in script

Anonymous — Wed, 10 May 2017 08:36:18 GMT

Hi Jessica,

Could you check the source field format? I guess there is some mis match in the format.

-Jai

Re: Variable as string in script

PrashantSangle — Wed, 10 May 2017 08:38:12 GMT

Hello,

try with double quotes

"$(vAcadyear)" as Year

Regards

Re: Variable as string in script

jessica_webb — Wed, 10 May 2017 08:38:19 GMT

Hi Jai,

I'm afraid I don't understand what you mean.

Re: Variable as string in script

Anonymous — Wed, 10 May 2017 08:40:15 GMT

With load inline work fine:

Set vAcadyear = '2016-17';

T:
LOAD * INLINE [
F1, F2
A, $(vAcadyear)
B, $(vAcadyear)
];

Can you try to write let = '2016-17'?

Re: Variable as string in script

Anonymous — Wed, 10 May 2017 08:40:33 GMT

Hi Jessica,

Can you share the sample data, that look alike? (If Possible )

-Jai

Re: Variable as string in script

jessica_webb — Wed, 10 May 2017 08:41:33 GMT

Hi Prashant,

That gives me the following error:

Field not found - <2016-17>

Centre_data:

LOAD

"2016-17" as Year,

Re: Variable as string in script

Anonymous — Wed, 10 May 2017 08:43:20 GMT

Jessica, try with let = '2016-17', it work.

Re: Variable as string in script

jessica_webb — Wed, 10 May 2017 08:46:03 GMT

Nope, still gives me '1999' as a value.

I'll upload a sample file on here.

Re: Variable as string in script

PrashantSangle — Wed, 10 May 2017 08:49:19 GMT

Yes it is working properly.

Regards,

Re: Variable as string in script

jessica_webb — Wed, 10 May 2017 08:49:58 GMT

I don't want it to say '1999' though. I want it to say '2016-17'

Re: Variable as string in script

tyagishaila — Wed, 10 May 2017 08:54:27 GMT

try it,

LOAD

'$(vAcadyear)' as Year,

Re: Variable as string in script

Anonymous — Wed, 10 May 2017 09:03:26 GMT

Maybe: '$(vAcadyear)' as Year?

Re: Variable as string in script

PrashantSangle — Wed, 10 May 2017 09:05:48 GMT

Hi,

try with single quote

Let vAcadyear = '2017-16';

Load ID,'$(vAcadyear)' as Year INLINE [

];

Regards

Re: Variable as string in script

jessica_webb — Wed, 10 May 2017 09:14:22 GMT

Thank you Shaila, that works perfectly