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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!