topic Select multiple values from a Field in QlikView

Select multiple values from a Field

Fri, 23 Apr 2010 07:36:40 GMT

Hi,

I want to write a Marco using VBScript. Upon event rising, the macro should select certain values from the related field. In my case, I have a field with values ranging from 0 to 6. If the user clicks the button, values from 4-6 should be selected.

Something like:

<code>

sub MYBUTTON
set f = ActiveDocument.GetField ("MYFIELD")
f.select (4 to 6)
end sub

</code>

Thanks in advance,

Klaus

Select multiple values from a Field

Fri, 23 Apr 2010 07:52:42 GMT

hi,

you can use

sub period

mySelect= ">=4" & " <=6"

ActiveDocument.Fields("myfield").Select mySelect

end sub

thanks

Select multiple values from a Field

Fri, 23 Apr 2010 08:07:04 GMT

Great, it worked!

Thanks a lot,

Klaus