topic Re: Multiple selections in a macro in QlikView

Multiple selections in a macro

Fri, 26 Apr 2013 22:06:01 GMT

Hi,

I would like to know if it is possible to set in a Macro the selection of each value in a filter one by one to make some task.

Example:

Start Macro --> Choose value "1" in the filter --> Task --> Choose value "2" in the filter --> Task --> ... --> Choose last value --> Task --> Finish Macro

Thank you for your time.

Re: Multiple selections in a macro

Anonymous — Mon, 29 Apr 2013 20:03:07 GMT

Sure. A simple example:

sub Macro
' Cycle by Field
set val=ActiveDocument.Fields("Field").GetPossibleValues
for i=0 to val.Count-1
ActiveDocument.Fields("Field").Select val.Item(i).Text
' YOUR TASK HERE
next

end sub

Regards,
Michael

Re: Multiple selections in a macro

Tue, 30 Apr 2013 14:55:24 GMT

Thanks,

I have already done it with the help of the QV API.

Thank you for your help and your time.