topic Macro select Value in QlikView

Macro select Value

Tue, 02 Jun 2009 20:48:04 GMT

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.

Macro select Value

Tue, 02 Jun 2009 20:53:11 GMT

sub selectTrue

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

end sub

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

Macro select Value

Anonymous — Tue, 02 Jun 2009 20:59:15 GMT

You can do it without macro in QlikView 9

Macro select Value

Wed, 10 Jun 2009 20:16:56 GMT

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

Macro select Value

Wed, 10 Jun 2009 20:46:32 GMT

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

Here's a sample.

Macro select Value

Fri, 12 Jun 2009 19:29:08 GMT

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

Macro select Value

Anonymous — Fri, 12 Jun 2009 19:47:19 GMT

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

Macro select Value

Fri, 12 Jun 2009 20:08:51 GMT

Thats great thanks