Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
If you reload your app new variable should be loaded.
What is the Copy problem?
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
Hi Anil,
Have a look this thread, might be helpful for you
You can use this little QlikView script to load your variables from an external source (text file / excel):
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)';
Next
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.
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.