Choosing Values

[#1]

Hello:

Im a new qlikview user.

I have a list of, say, employee numbers 1-1000 in the first column of the table. With each row on that table having more information on those employee numbers. How can I make a button that will make the table display only employee numbers that are, say, 900? or a range of employee numbers like 300-400?

Thanks!

[#2]

Hi,

You can use this MACRO:

SUB Range

          ActiveDocument.Fields("YOUR_FIELD").Select "5*"

          ActiveDocument.Fields("YOUR_FIELD").ToggleSelect "6*"

END SUB

Add a button using the macro.

[#3]

Is there a different way to do it other than a macro?

[#4]

Yes, i find now this way

Insert two action on your button

1. "Select in Field"  on your field with the filter ="5*"

2. insert the "Toggle Select" on your field with the filter ="6*"