topic Passing variable values from a QVW to another QVW and using it in that script in QlikView

Passing variable values from a QVW to another QVW and using it in that script

vvira1316 — Thu, 21 Jul 2016 22:55:31 GMT

Hi,

I've a situation where I've to call another QVWs using execute script line.

Below is the script portion of Main QVW that is calling several other QVWs for execution. In script of other QVWs I've to use start (vS) and end (vE) dates used in Main Script for date range in selecting data within those called QVW scripts

let vScriptDirectory = '..\Scripts\';

let vS = '01/01/' & Year(Today());
let vE = If(Num(Month(MonthEnd(today(),-2))) < 9, '0' & Num(Month(MonthEnd(today(),-2))), Num(Month(MonthEnd(today(),-2)))) & '/' & Day(MonthEnd(today(),-2)) & '/' & Year(MonthEnd(today(),-2));

execute "C:\Program Files\QlikView\Qv.exe" /r /vvStart='$(vS)' /vvEnd='$(vE)' $(vScriptDirectory)FirstScript.qvw;
load 'FirstScript Completed.' as Log, now() as DtTm AutoGenerate 1;

execute "C:\Program Files\QlikView\Qv.exe" /r /vvStart='$(vS)' /vvEnd='$(vE)' $(vScriptDirectory)SecondScript.qvw;
load 'SecondScript Completed.' as Log, now() as DtTm AutoGenerate 1;

load 'Main Script Completed.' as Log, now() as DtTm AutoGenerate 1;
exit script;

Portion of called QVW script

DataTab:
LOAD
FIELD1 as F1,
FIELD2 as F2,
DATE_FIELD as DATE,
FROM

[saved.qvd]
(qvd)
WHERE
[DATE_FIELD] >= '$(vStart)' and [DATE_FIELD]<= '$(vEnd)' ; //these vStart and vEnd should use values that are available in vS and vE of calling QVW script.

Called scripts generates QVDs. Please advise what script modification is required in calling or called scripts to make this working or if any variables have to be defined in the called script.

Thanks,

Vijay

Re: Passing variable values from a QVW to another QVW and using it in that script

marcus_sommer — Fri, 22 Jul 2016 05:30:45 GMT

If I have the need to share variables or parameters between various qvw's and also different programs I store them into txt-files as a variable-statement (quite rarely) and more often as simple parameter like run/stop/any date or within a table-structure - which you could easily read again in qlikview and other programs, too.

- Marcus

Re: Passing variable values from a QVW to another QVW and using it in that script

settu_periasamy — Fri, 22 Jul 2016 05:48:33 GMT

as already suggested by marcus, you can store your variable values (may be text or qvd) then you can use that in your other qvw. like

let vS = '01/01/' & Year(Today());
let vE = If(Num(Month(MonthEnd(today(),-2))) < 9, '0' & Num(Month(MonthEnd(today(),-2))), Num(Month(MonthEnd(today(),-2)))) & '/' & Day(MonthEnd(today(),-2)) & '/' & Year(MonthEnd(today(),-2));

Date_variable:
LOAD * Inline [
Startdate,EndDate
$(vS),$(vE)
];

STORE Date_variable into Date_variable.qvd(qvd);

Load your Date_variable table;

//use the peek statement here create the variable;

DataTab:
LOAD
FIELD1 as F1,
FIELD2 as F2,
DATE_FIELD as DATE,
FROM

[saved.qvd]
(qvd)
WHERE
[DATE_FIELD] >= '$(vStart)' and [DATE_FIELD]<= '$(vEnd)' ;

Re: Passing variable values from a QVW to another QVW and using it in that script

vvira1316 — Fri, 22 Jul 2016 20:52:09 GMT

Thank you Marcus

Re: Passing variable values from a QVW to another QVW and using it in that script

vvira1316 — Fri, 22 Jul 2016 20:53:09 GMT

Thank you Settu. Its working.