topic Pick/Match with Variable - Easy One in QlikView

Pick/Match with Variable - Easy One

Tue, 02 Oct 2012 22:20:29 GMT

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)

Re: Pick/Match with Variable - Easy One

Anonymous — Wed, 03 Oct 2012 01:59:12 GMT

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.

Re: Pick/Match with Variable - Easy One

Wed, 03 Oct 2012 02:07:37 GMT

What is the syntax for the Select in Field field?

Re: Pick/Match with Variable - Easy One

Anonymous — Wed, 03 Oct 2012 02:23:42 GMT

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

Re: Pick/Match with Variable - Easy One

Wed, 03 Oct 2012 13:31:42 GMT

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