How can I use concatenated string as parameter in Dollar Sign Expansion ?

saveriospa — Tue, 01 Aug 2017 15:52:44 GMT

Hi to all !

I've two tables with the same set analysis expressions with parameters, in order to perform calculation with different measures.

I made them dynamic defining the set analysis inside a variable.

For example :

v_Var1

sum( {$< ... >} $1 )

But there are also variables with two parameters :

v_Var2

sum( {$< ... >} $1,$2 )

Table 1

Expression 1 : $(v_Var1(ABC_SALES_D))

Expression 2 : $(v_Var2(ABC_SALES_D , XYZ_SALES_X))

Table 2

Expression 1 : $(v_Var1(ABC_QUANTITY_D))

Expression 2 : $(v_Var2(ABC_QUANTITY_D , XYZ_QUANTITY_X))

In the script i create a simple inline table with a single filed Sales_Quantity, that can assume two values : SALES and QUANTITY.

Afterward, i create a variable, v_sales_quantity, that catch the value selected by the user :

SubField(GetFieldSelections([Sales_Quantity]),',',-1)

All with the intention of manipulate the parameter inside the dollar expansion to make everything dynamic based on user selection, with expressions like this :

$(v_Var1($('ABC_'&'$(v_sales_quantity)'&'_D')))

$(v_Var1($('ABC_'&$(v_sales_quantity)&'_D')))

$(v_Var1($(Text('ABC_'&$(v_sales_quantity)&'_D'))))

But without results.

I'm missing something or this string manipulation is not possible for the parameter?

Many Thanks!!

Saverio

Re: How can I use concatenated string as parameter in Dollar Sign Expansion ?

saveriospa — Wed, 02 Aug 2017 08:20:59 GMT

I found the solution !

$(v_Var1("$(='ABC_'&$(v_sales_quantity)&'_D')"))

topic How can I use concatenated string as parameter in Dollar Sign Expansion ? in QlikView

How can I use concatenated string as parameter in Dollar Sign Expansion ?

Re: How can I use concatenated string as parameter in Dollar Sign Expansion ?