topic ActiveDocument.Select multiple months in QlikView

ActiveDocument.Select multiple months

Fri, 31 Jul 2009 23:22:54 GMT

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.

ActiveDocument.Select multiple months

hector — Fri, 31 Jul 2009 23:54:02 GMT

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

Regards & good luck

ActiveDocument.Select multiple months

Sat, 01 Aug 2009 00:58:09 GMT

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"