Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gerald_lebret
Partner - Creator
Partner - Creator

New variable teext box feature

Hi,

 

Since we now have the possibility to enter a variable in an application, I was wondering if it would be possible to use the text entered in that box in the script load.

 

Let me give a few more explanation. Most of my scripts execute sql queries. In these queries I have to specify some values (eg. where…= …, @in_parameter1 =…). I would like to specify in my app, the value of one of these parameters, Then when I reload the script, Qlik Sense would understand that it has to go fetch that value for that specific parameter.

 

If anyone can help me, I would be really grateful. If you have any further questions, please feel free to get in touch.

 

Best Regards.

 

G. LEBRET

 

 

Labels (1)
2 Replies
rubenmarin

Hi, variable values can be used in script using $-expansion, like in expressions:

where value = '$(variableName)' 

 

$(variableName) will be converted to the value stored in variable. Using buttongs or dropdown you can limit values listed, text box is very open.

gerald_lebret
Partner - Creator
Partner - Creator
Author

Works like a charm. Thank you very much