Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JacobJones
Creator
Creator

Qlik Sense variables

How can I set a variable that is updated by user input. Say I have a field, Program, that has a filter pane. When the user selects a Program from the filter pane I would like a variable, vProgram, to be updated so that it can be consumed in other functions. This is for Qlik Sense and the data is already loaded. I want to do this from the variables window.
1 Solution

Accepted Solutions
DavidM
Partner - Creator II
Partner - Creator II

If you don't want to use Input box, but want to use input from Filter Panel you can use GetFieldSelections:

Let vProgram = GetFieldSelections([Program],'","')

And use it like this in formula. However, you might want to consider limiting the formula to use only 1 value of the selected, as more selected values may cause troubles with your formulas. Check Qlik help

 

View solution in original post

2 Replies
Yoshidaqlik
Creator II
Creator II

Hi,

can create the variable and link it to an input box

as well as using this variable in all measures

Capture.PNG

regards

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng
DavidM
Partner - Creator II
Partner - Creator II

If you don't want to use Input box, but want to use input from Filter Panel you can use GetFieldSelections:

Let vProgram = GetFieldSelections([Program],'","')

And use it like this in formula. However, you might want to consider limiting the formula to use only 1 value of the selected, as more selected values may cause troubles with your formulas. Check Qlik help