Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview User
I am using an Excel spreadsheet to store all my variables and then referring to the spreadsheet only should I need to change an expression
I have just created a variable which has a pathway where I would like to store all my QVD'S
I.e
v_QVDPathway \\rhmqlikdev\C$\\InfoQlik\QVD\
I then load the spreadsheet into my QVW
I was wondering if someone could kindly help me write the final Store statement, where I use v_QVDPathway
I.e. Store Table1 into v_QVDPathway/Table1_For_Store.qvd.(qvd)
Any help would be greatly appreciated
Hi Helen,
see attached, after the following, you'll have your variable in the qlikview environment and can use it, i.e:
store tablename into $(v_QVDPathway)tablename.qvd.
Please mark as correct answer if I helped.
Vars:
LOAD * INLINE [
Variable, Expressions
v_QVDPathway, \\rhmqlikdev\C$\\InfoQlik\QVD\
];
Let vNumOfRows= NoOfRows('Vars');
For vI = 0 to (vNumOfRows- 1)
Let vTempVar= Peek('Variable',vI,'Vars');
Let [$(vTempVar)] = Peek('Expressions',vI,'Vars');
Next;
BR,
Eliran.
Hello Eliran
The following expression worked for me
Store Table1 into $(vQvdLayerPathName)/Table1.qvd(qvd);
Thanks for your suggestion