topic Re: How to include variables inside variables in script? in QlikView

How to include variables inside variables in script?

Anonymous — Fri, 20 Nov 2020 18:02:30 GMT

Hello everyone,

I am trying to pass all my expression to the script, so that it will be easier to maintain and Debug.

However i am struggling with including an expression within another expression in the script.

Outside the script when i create the variables through the "Variable Overview" window, they work, however i cannot make them work when they are created in the script.

I have tried many combinations but none result in what i expected.

In the script i wrote the following:

LET vPeriodSelectionSales = '=Max({1<FLAG_Sales = {1}, Month = P(Month), Year = P(Year)>} Period)';

LET vYearSelectionSales = '=Max({1<FLAG_Sales = {1}, Month = P(Month), Year = P(Year)>} Year)';

LET vPeriodYearBeginning = '=Min({1<FLAG_Sales = {1}, Month = P(Month), Year = {$(vYearSelectionSales)} >} Period)';

I tried using "", using SET instead of LET, and many other combinations, but I cannot make vPeriodYearBeginning work because it is calling another variable. How can i make this variable work?

Can anyone help me please?

Thank you in advance,

Susana

Re: How to include variables inside variables in script?

sunny_talwar — Mon, 14 Sep 2015 18:14:21 GMT

See if this thread is of any help: variables within variables in load script

Re: How to include variables inside variables in script?

MarcoWedel — Mon, 14 Sep 2015 21:32:33 GMT

Hi,

maybe parameterized variables could be a solution also.

regards

Marco

Re: How to include variables inside variables in script?

fkeuroglian — Tue, 15 Sep 2015 01:16:18 GMT

susana, how are you?

could you put your. qvw as an example, to be easier to help you?

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

Susana como estas?

podrias subir el .qvw para ver donde esta el tema que no cargan las variables y asi sera mas facil ayudarte

saludos,

Fernando K.