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

This widget could not be displayed.

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pick/Match with Variable - Easy One

Could someone please help me out with the following?  

I have a QV field called Name, populated with people's names.

I have a variable, vName, that someone can select a name from a drop down list.

I need the field Name to become selected based on whatever the end user choose for vName.

I am sure I can do this with Pick/match, just not sure the exact syntax with a variable.

Something like  =Pick(Match($(vName),"Bob")+1, GetFieldSelections(Name), Bob)

This widget could not be displayed.
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

So.. based on a variable (vName) changing value you want to make a selection in the field Name?

In that case you can go to Settings > Document Properties > Triggers and set up a Variable Event Trigger OnInput/OnChange for your vName variable and set the action to "Select in Field". You can then make a selection in the field Name based on the variable value for example.

View solution in original post

This widget could not be displayed.
4 Replies
Anonymous
Not applicable
Author

So.. based on a variable (vName) changing value you want to make a selection in the field Name?

In that case you can go to Settings > Document Properties > Triggers and set up a Variable Event Trigger OnInput/OnChange for your vName variable and set the action to "Select in Field". You can then make a selection in the field Name based on the variable value for example.

This widget could not be displayed.
Not applicable
Author

What is the syntax for the Select in Field field? 

This widget could not be displayed.
Anonymous
Not applicable
Author

Field - This is the field name

Search string - This is what you're trying to select in the field. I guess in your case it's '$(vName)'

This widget could not be displayed.
Not applicable
Author

Putting in =$(vName) did the trick, thanks much!

This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.