I have a QlikView where when a certain sheet is opened I would like to have two quarters of the financial year selected so I can view data side by side.
I have it working perfectly if I have the field selectors on screen and manually select the two quarters that I would like. However, I seem to be having difficulty getting my macro to select more than one quarter at a time.
This is what I have at the moment:
Sub ScoreCard() ActiveDocument.ActivateSheetByID "SH21" ActiveDocument.GetField("Quarter").Select "2009/10 Q2" End Sub
Please could anyone advise how I make it select both "2009/10 Q2" and "2009/10 Q3"