Select values with separate key

[Anonymous]

Good Day Everybody!

I have next situation.

Users need selected some of SKU (50-100 values). They put it into input box with separate key like ";" (for example: 550;591;790;145;452...) and run a macro that selected all needed values.

Could somebody help me to write this macros.

Thanks everyone who helps.

With best regards, AGolovkin!

[Miguel_Angel_Baeyens]

Hi,

There shouldn't be any need for macros. You can use actions to select in one field the values in the variable. The search string in the action should have parentheses and use the "|" instead of ";".

(550|591|790)

Hope that helps.

Miguel

[giakoum · Accepted solution]

You do not need a macro, just an action :

Create a button

for this button create an action select in field

write the field name i.e. vName to be filtered

in search string write : ='=sum({<vName={"($(Variable1))"} >} 1)'

create an input box for Variable1

have the users input values like this : 550|591|790|145|452 

| is default separator for QV

see attached file

[Anonymous]

Thanks, Guys.

You realy help me!

[Miguel_Angel_Baeyens]

Hi there,

And even easier, and leaving the user use the ";" separator as they were, in the attached document, and using in the Search String of the action

='(' & Replace(vSelect, ';', '|') & ')'

Hope that helps.

Miguel