Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Is there a different way to do it other than a macro?
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*"