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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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)

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

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.

Not applicable
Author

What is the syntax for the Select in Field field? 

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)'

Not applicable
Author

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