topic Re: Load variable from text file in QlikView

Load variable from text file

gerhardl — Thu, 22 Aug 2013 15:24:24 GMT

Hi there,

If I have a text file named "vPQLow.txt" that contains only a single value (e.g. "54"), how can I get this value and use the 54 as a variable in my Load script?

What I am doing is working from a Powershell script which allows a user to input a campaign number, and this will then create a file with that number in it - I then need to use this number as a variable in QLikView.

Re: Load variable from text file

Thu, 22 Aug 2013 15:29:34 GMT

Hi Gerhard,

Hope the below script helps you.

Variable_Table:

LOAD @1

FROM

Variable_Txt.txt

(txt, codepage is 1252, explicit labels, delimiter is '\t', msq);

LET X=NUM(Peek('@1',0,'Variable_Table'));

Re: Load variable from text file

gerhardl — Thu, 22 Aug 2013 15:36:57 GMT

Thanks Ajay,

I actually just figured out another way to do it, which I think works a bith better. In PowerShell i create the text file to not just right "54", but rather to write "LET vPQLow = 54;"

And then I do this in my QV Script:

$(Include=C:\Path\vPQLow.txt);

Re: Load variable from text file

Thu, 22 Aug 2013 15:55:50 GMT

Thanks Gerhard.

That seems to be much easy way than what i posted

Keep sharing the new findings.

Regards,

Achiever