topic Re: Macro to select multiple values in the single field in QlikView

Macro to select multiple values in the single field

Tue, 07 Apr 2015 20:06:57 GMT

I need to select multiple values in the single field

Example:

County

Japan

Singapore

Korea

China

Germany

USA

London

Brazil

Canada

I have to reduce the data and save the file only with Japan and China.

Another file will be USA,Canada.

Country is the field is linked with other tables. I would like to do this filtering only in the macro.

Thanks in Advance for your help.

Re: Macro to select multiple values in the single field

Anonymous — Tue, 07 Apr 2015 20:28:03 GMT

I am not very clear about why you want to use macro.

Are these statdard groupings or random?

Do you want to manually reduce the files or thru publisher?

Why not create another field for these groupings and use that field for the reducing of the files?

Re: Macro to select multiple values in the single field

Gabriel — Tue, 07 Apr 2015 21:15:19 GMT

Hi,

First am not sure the explanation is clear.

If you wish to reduce and save a file containing information for a particular country, why not reduce in the script, just have a WHERE clause, i.e. WHERE Country ='Japan' OR Country ='China'...

Then STORE

INTO c\filelocation.

Also, if this is to prevent user from having access to other country's data then you can implement SECURITY read this blog by HIC, https://community.qlik.com/blogs/qlikviewdesignblog/2014/06/09/methods-for-data-reduction.

This are just general suggestion. If you can explain what you wish to achieve then someone from the community will give you more accurate suggestion.

Re: Macro to select multiple values in the single field

Tue, 07 Apr 2015 21:26:23 GMT

Would Bookmark be another alternative?

Re: Macro to select multiple values in the single field

Wed, 08 Apr 2015 13:22:02 GMT

Book mark and Where clause is not solve the problem.

I am looking for Macro to reduce the data .

Re: Macro to select multiple values in the single field

jerrysvensson — Wed, 08 Apr 2015 14:25:09 GMT

sub JapanChina
ActiveDocument.Fields("Country").Select "(Japan|China)"

end sub

sub USACanada
ActiveDocument.Fields("Country").Select "(USA|Canada)"

end sub

Re: Macro to select multiple values in the single field

Wed, 30 Sep 2015 12:30:28 GMT

Hi Jerry what if one of the fields has a space? i am struggling with one:

sub JapanSouthAmerica
ActiveDocument.Fields("Country").Select "(Japan|South America)"

end sub

Thanks,

Re: Macro to select multiple values in the single field

marcus_sommer — Wed, 30 Sep 2015 12:58:33 GMT

An possibility would be to use multiple double-quotes like:

"(""Japan""|""South America"")"

or you used toggleselect:

ActiveDocument.Fields("Country").Select "Japan"

ActiveDocument.Fields("Country").ToggleSelect "South America"

- Marcus