topic Re: Select multiple values programmatically in QlikView

Select multiple values programmatically

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Nicole-Smith — Mon, 06 Nov 2017 17:05:29 GMT

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.

Anonymous — Mon, 06 Nov 2017 17:07:26 GMT

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

Thank you.