topic Re: Nesting Variables with parameters in QlikView

Nesting Variables with parameters

Fri, 23 May 2014 11:19:54 GMT

I'm trying to pass the results of a variable with parameters to another variable having parameters but I can't quite get it to work. I have this 2 variables which work when they are not nested.

eNetScenMV = Sum ({$<$(vMonthEnd), [Account Type]=, [Scenario]={$1}>} [#Market Value Usd])

usage: $( eNetScenMV("PC1-") )

eSumOfSquares = sqrt( sqr($1) + sqr($2) + sqr($3) )

usage $( eSumOfSquares(1, 2, 3) )

I need to use the results of eNetScenMV as parameters to eSumOfSquares like so in a TEXT object:

=$(eSumOfSquares($(eNetScenMV("PC1-")), $(eNetScenMV("PC2-")), $(eNetScenMV("PC3+"))))

When I do this I get an "Error in Set Modifier Expression". I've tried a number of things but cannot get it to work. I appreciate any help on this.

Re: Nesting Variables with parameters

Fri, 23 May 2014 11:56:09 GMT

Nasario,

please try:

$(eSumOfSquares($(=$(eNetScenMV("PC1-"))), $(=$(eNetScenMV("PC2-"))), $(=$(eNetScenMV("PC3+")))))

Re: Nesting Variables with parameters

Fri, 23 May 2014 12:28:23 GMT

Thanks Dariusz Mielczarek this worked! I'm still trying to understand this dollar expansion business . Does the inner dollar expansion =$(eNetScenMV("PC1-") get the expression to be expanded by the outer $(...)?

Re: Nesting Variables with parameters

Slawomir — Thu, 04 Jun 2020 20:58:55 GMT

Hello everybody,

I have a similar problem, but I couldn't solve it. Would you help me, please?

I have 2 SET-variables:

Set vTest1=left($1,$2);
Set vTest2=right($1,$2);

Test-Solution with variable #1:

Let X = $(vTest1('Hello you',7));
Trace '$(X)'; //the solution is 'Hello y'

Test-Solution with variable #2:
Let X = $(vTest2('$(X)',1)); // or Let X = $(vTest2('Hello you',1))
Trace '$(X)'; //the solution is 'y'

Now I nest the two variables together:

Let X = $(vTest2($(vTest1('Hallo you',7)),1));
Trace '$(X)'; // the solution is an error

I tried another way (similar to your solution):

Let X = $(vTest2($(=$(vTest1('Hallo you',7))),1));
Trace '$(X)'; // but, the solution is an error too

Re: Nesting Variables with parameters

E_Røse — Fri, 06 Jan 2023 21:13:01 GMT

Slawomir, Did you find a solution to this?

Re: Nesting Variables with parameters

marcus_sommer — Mon, 09 Jan 2023 08:44:15 GMT

Nesting of variables failed mostly because each included comma is treated as parameter-delimiter of the variable. Also the creating and calling syntax is depending on the specific context.

Even if it's possible to develop working solutions the nesting of variables could become quite complex - much more as it would be sensible within the most scenarios because the aim of variables is to simplify things and not to gain the opposite ... Therefore my suggestion - keep it simple.

Re: Nesting Variables with parameters

E_Røse — Mon, 09 Jan 2023 10:47:28 GMT

@marcus_sommer

Not using a nested variable is not option (this time).

The problem seems to be that I cannot avoid the inner variable being evaluated during the load (which does not work with the $1 placeholder in the inner parameter). It works if I create the definition in the UI (which I was hoping to avoid).

I can create this parameter pTemplate_DimAColumn_Show in th UI $(pTemplate_DimAColumn_ShowCondition2($(=$(pTemplate_DimAColumn($1))))) and it works as expected.

In the load on the other hand, the inner parameter just evaluates to missing value and I get the same result as just writing: $(pTemplate_DimAColumn_ShowCondition2($1)).

Re: Nesting Variables with parameters

marcus_sommer — Mon, 09 Jan 2023 10:40:28 GMT

This kind of $-sign expansion: $(= ... ) isn't available within the script else it's UI only. This means you need either a different logic how the variables are designed and later used or you remain by the working solution by creating the variables within the UI (beside this I'm not so sure if it has really benefits to create UI variable within the script).

Re: Nesting Variables with parameters

E_Røse — Mon, 09 Jan 2023 11:07:56 GMT

I do not really want to evaluate anything within the script. I just want to create a string that I will evaluate later.

Load scripts and charts/tables are fast to copy to another app. Variables in the UI are not. So in the end, I will add it to the table instead.

Re: Nesting Variables with parameters

marcus_sommer — Mon, 09 Jan 2023 14:11:59 GMT

There are various ways to transfer variables between documents like macros, reading the meta-data, using prj-folders, ... I think there were even more which I don't remember yet and unfortunately a lot of older community-content to these topic isn't available anymore.

But you are right it's not so easy as copy & paste from script or objects ... but you may also copy & paste of applications and then removing any unwanted stuff.