Macro select Value

[#1]

Hi,

I have a field "status" with 2 possible values (true/false). I'd like to have a button which select true by clicking.
I guess I'll have to handle this with a macro. I'm a newbie and haven't done anything with macros.
So, thanks for your help.

[#2]

sub selectTrue

ActiveDocument.Fields("status").Select "true"

end sub

you can attach above macro function - selectTrue - to the button to select status as true

[Anonymous]

You can do it without macro in QlikView 9

[#4]

Hi,

LOAD * INLINE [
USER, X1, X2
"User 1", true, true
"User 2", false, true
"USer 3", true, false
"User 4", false, true
"User 5", true, true
];

I created a button (1) and used ActiveDocument.Fields("X1").Select "true" to select.

Now I'd like to select the X2 true. If Button 1 was activated first I only get the users that are X1 true and x2 true.
I'd like to select only the users with X2 true.

I tried ActiveDocument.Fields("X1").Clear

and then again X2 Select.
Unfortunately this isn't working.
Any ideas?

Thanks

Elzo

[#5]

That seems like it should work. Are you getting an exception in the macro or is nothing happening?

Here's a sample.

[#6]

Do you know how to do it in Qlikview 9 - i've tried using triggers but I can't get it to work.

Thanks

Helen

[Anonymous]

Helen,
Same functionality in QV9, no macro needed. See attahced.

[#8]

Thats great thanks