topic Re: Select values with separate key in QlikView

Select values with separate key

Anonymous — Tue, 26 Jun 2012 06:59:19 GMT

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!

Re: Select values with separate key

Miguel_Angel_Baeyens — Tue, 26 Jun 2012 07:16:36 GMT

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

Re: Select values with separate key

giakoum — Tue, 26 Jun 2012 07:18:50 GMT

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

Re: Select values with separate key

Anonymous — Tue, 26 Jun 2012 07:21:16 GMT

Thanks, Guys.

You realy help me!

Re: Select values with separate key

Miguel_Angel_Baeyens — Tue, 26 Jun 2012 07:28:49 GMT

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