Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
sidneylu
Contributor III

Select multiple values programmatically

Hello,

In a sub routine, how would I select (or pre-select) multiples values?

Currently I use something like this to choose a single state but I now want to choose two or more states.

ActiveDocument.Fields("State").Select "CA"

ActiveDocument.Fields("State").Select "TX"

Thanks!

Tags (1)
2 Replies
Highlighted

Re: Select multiple values programmatically

I would assume it would work the same way as trying to select multiple values within the tool itself:

ActiveDocument.Fields("State").Select "(CA|TX)"


Disclosure: I haven't test this, just going off of what I already know about the tool.

Highlighted
sidneylu
Contributor III

Re: Select multiple values programmatically

Ah... I was missing the parenthesis.  That's why it didn't work for me before posting this question.

Thank you.