topic Re: Variable Copy Problem in QlikView

Variable Copy Problem

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

Dear,

I have my all variable in one Notepad

Now, I am getting those variables using The Include statement. In future, If i update my variable from Notepad i want to applicable qvw file also.

Can anyone Assist me?

Re: Variable Copy Problem

robert_mika — Wed, 27 Jul 2016 08:27:23 GMT

If you reload your app new variable should be loaded.

What is the Copy problem?

Re: Variable Copy Problem

Anil_Babu_Samineni — Wed, 27 Jul 2016 08:34:59 GMT

Here, i want to fetching that Notepad variables into Qlikview? Is that is possible? I am using Include statement. Here, For next level if i change my path on my variable from Notepad then should be path need to change in Qlikview file also. I apologize my english

Re: Variable Copy Problem

Wed, 27 Jul 2016 08:39:25 GMT

Hi Anil,

Have a look this thread, might be helpful for you

Include Statement with a variable relative path

Re: Variable Copy Problem

swuehl — Wed, 27 Jul 2016 08:40:03 GMT

You can use this little QlikView script to load your variables from an external source (text file / excel):

Set Analysis in Expression (Chart)?

Re: Variable Copy Problem

Frank_Hartmann — Wed, 27 Jul 2016 08:40:42 GMT

have a look here:

Importing and exporting variables - The Qlik Fix! The Qlik Fix!

hope this helps!

Re: Variable Copy Problem

rubenmarin — Wed, 27 Jul 2016 08:43:26 GMT

Hi Anil, using 'Include' it will load the content of the txt as it is, I don't think it will do anything.

To work only with the include the content of the file should be like:

LET a = 2;

LET vPath = 'D:/Location/File';

....

Other approach, can be load the values as a file and create the variables in a bucle (without the 'include'):

Variables:

LOAD @1 as varName,

@2 as varContent

FROM

[.\Variables.txt]

(txt, utf8, no labels, delimiter is ';', msq);

For i=0 to NoOfRows('Variables')-1

LET varName = Peek('varName', $(i));

LET varContent = Peek('varContent', $(i));

LET $(varName) = '$(varContent)';

DROP Table Variables;

LET varName = ;

LET varContent = ;

Note: Things like simple quotes or dollar expansions '$(' in the txt files can cause issues when loading into QlikView. There are some workarounds to avoid this.

Re: Variable Copy Problem

Anil_Babu_Samineni — Wed, 27 Jul 2016 08:44:33 GMT

Yes, That is in Excel. After that i want to send that Data into Text. Then I want to load that Notepad(Text) into Qvw.