Storing Pathway name in spreadsheet and then using pathway to store QVD

[helen_pip]

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

[eliran]

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.

[helen_pip]

Hello Eliran

The following expression worked for me

Store Table1 into $(vQvdLayerPathName)/Table1.qvd(qvd);

Thanks for your suggestion