Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ActiveDocument.Select multiple months

Hi All,

How can I use a macro using ActiveDocument.GetField("Month").Select to select multiple months?

I am able to select a singular year and singular month but I need to select multiple months.

Thanks,

Kevin.

2 Replies
hector
Specialist
Specialist

HI, if month is a numerical value, you can use .Select ">=3 <=6"

Regards & good luck

H.

Not applicable
Author

To select non-consecutive months, you would have to utilize ToggleSelect.

ActiveDocument.GetField("Month").Select "April"
ActiveDocument.GetField("Month").ToggleSelect "June"
ActiveDocument.GetField("Month").ToggleSelect "December"