Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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