Macro with qlik

[#1]

Hi,

I had a doubt with a Macro, i have the code to export and save the document in csv but is it possible to filter the table in the macro?

Thank you

[marcus_sommer]

Here a few examples from the APIGuide.qvw (is in your install-folder by automation):

ActiveDocument.Fields("Month").Select "September"

ActiveDocument.Fields("Month").Select "J*"

ActiveDocument.Fields("Sales").Select ">1500"

- Marcus

[vinieme12]

Preferably use Trigger Actions

[saimahasan]

You can use these lines of code:

SET Doc = ActiveDocument

SET Field = Doc.Fields("X_REGION_DESC").GetPossibleValues

Doc.FIelds("X_REGION_DESC").SELECT "Great Lakes"