Get Variable Value of an App

[acgomes]

Hello,

I am using the Get Variable block from the Qlik Cloud Services connector. Currently, I get the following output from this block:

{ "qInfo": { "qId": "56e41a04-d51d-4529-b2a6-27411a63b39d", "qType": "variable" }, "qMetaDef": [], "qName": "vTest", "qNumberPresentation": { "qType": "U", "qnDec": 10, "qUseThou": 0 }, "qDefinition": "=$(vExpression)", "tags": [] }

The definition $(vExpression) is built based on user inputs in an QS app, which returns a number, the value of the variable. I need this number during the reload of another app.

It seems I can not get the value of a variable using the Get Variable block. There is any way to get the variable's value from an QS app in an automation?

Thanks.

[Vinay_B · Accepted solution]

Hi @acgomes,

The variable in your case needs to be evaluated. Evaluate the qDefinition in an expression and pass that. Let me know if this helps!

[acgomes]

Hello @Vinay_B 

Thanks for the help, when you write of evaluate the expression, how and where am I supposed to do this, on the automation? I did try to use the Get Expression Value block, but there was no output.

Let me provide some detail, the content of the qDefinition I need to evaluate is something like this:

=Max({<SELECTED_OPTION_NAME={'$(vOptionSelected)'}>} ID_SELECTED_OPTION)

In the first App, I have a variable input configured as a list box. The user selects an option based in the name "SELECTED_OPTION_NAME", which is stored in the variable vOptionSelected. This expression is then used to retrieve the ID of the option stored "ID_SELECTED_OPTION". Each option has only one ID, so as far as I know, does not matter whether I use Max, Sum or any other agg function.

"SELECTED_OPTION_NAME" is a proper field, but in the list box I do not show all values of this field, only the ones that can be selected based in a flag which comes with the data. Something like this:

=Concat( {<FLAG_SELECTABLE_OPTION={'1'}>} SELECTED_OPTION_NAME, '|')

I hope this provide some context and help to understand what I am doing.

Thanks!

[acgomes · Accepted solution]

Hello,

I believe it worked. Apparently, we still need to manually add the "$( )" in between the qDefinition in order to the Get Expression Value block to work.

Thanks @Vinay_B , I am tagging both this and your post as solutions.