Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
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.
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
I have already done it with the help of the QV API.
Thank you for your help and your time.