Loading variables into Qlikview - period hard coded

paul_ripley — Sat, 16 Nov 2024 02:22:57 GMT

Hello

I have a spreadsheet full of variables, which I load into Qlikview using

$(Must_Include=..\..\06_sys\config\Template_STD_Variables.txt);

Template_STD_Variables.txt contains the following script

VariableList:
LOAD VName,
VContent
FROM
[..\..\06_Sys\Config\Variable List.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where not isnull(VName);

For vCount = 0 to NoOfRows('VariableList')-1
Let vName=Peek('VName',vCount,'VariableList');
Let vContent=Peek('VContent',vCount,'VariableList');
Let $(vName)='$(vContent)';
Next vCount
Let vCount=null();
Let vContent=null();
Let vName=null();
Drop Table VariableList;

The issue is that I am unable to amend the periods in the app after they have loaded.

For example this is the variable that I want to load into the app

=sum({$<period ={">=$(vStartPeriod_IS_CY)<=$(vEndPeriod_CY)"}, pl_line_mgmt = {'Gross investment return'}, bussline_abrev = {'PE'}>} IS_Investment_Adj_GBP) *-1
+
sum({$<period ={">=$(vStartPeriod_IS_CY)<=$(vEndPeriod_CY)"}, pl_line_mgmt = {'Gross investment return'}, bussline_abrev = {'PE'}>} IS_Investment_GBP) *-1

What actually is in the variable in the app is ie the periods are hardcopded and cant be changed in the app.

How can i just load the variable without the periods in them

=sum({$<period ={">=201801<=201806"}, pl_line_mgmt = {'Gross investment return'}, bussline_abrev = {'PE'}>} IS_Investment_Adj_GBP) *-1
+
sum({$<period ={">=201801<=201806"}, pl_line_mgmt = {'Gross investment return'}, bussline_abrev = {'PE'}>} IS_Investment_GBP) *-1

Many thanks

Re: Loading variables into Qlikview - period hard coded

Vegar — Thu, 26 Sep 2019 09:48:47 GMT

Try to avoid the use of the vContent to temporary store the expression code, but instead do the peek() when defining the variable like this:

VariableList:
LOAD VName,
VContent
FROM
[..\..\06_Sys\Config\Variable List.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where not isnull(VName);

For vCount = 0 to NoOfRows('VariableList')-1
Let vName=Peek('VName',vCount,'VariableList');
Let $(vName)=Peek('VContent',vCount,'VariableList');
//Let $(vName)='$(vContent)';
Next vCount
Let vCount=null();
Let vContent=null();
Let vName=null();
Drop Table VariableList;

Re: Loading variables into Qlikview - period hard coded

paul_ripley — Thu, 26 Sep 2019 11:29:48 GMT

thanks so much that worked and is super helpful!

topic Re: Loading variables into Qlikview - period hard coded in QlikView

Loading variables into Qlikview - period hard coded

Re: Loading variables into Qlikview - period hard coded

Re: Loading variables into Qlikview - period hard coded