macro button

[#1]

Hi everybody!

I´m preparing a qlikview to other users and I recorded some bookmarks. Is there any option to asign bookmark to buttons? I think it should be best way to other users to obtain results.

Thank you for your responses

Fiber9906

[#2]

I really appreciate your help. Thank you.

Just curiosity, which is the version you running?

Fiber9906

[Bill_Britt · Accepted solution]

Open the document and you can do a ctrl+m to open the Marco editor. You will see the macro BM and if you look you will see the bookmark name (test) in the call. On the Sheet "New Rules" you will see the button. Just look at the properties to see have it works.

Note. It would not let me post the file as Films.QVW so I rename it to Films.doc. You will need to rename it to films.qvw to make it work..

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8765.Films.doc:550:0]

[#4]

Very good answer!! It works perfectly!!

Lots of thanks!!

Fiber9906

[#5]

Just two more questions:

If I want with a macro to select a bookmark and to open one pivot table report, what should I do?

Now my code is

sub

CUADRE

activedocument.recalldocbookmark "CUADRE_TERCEROS"

end

sub

In this way, I was looking for something like activedocument.openpivottable "XXXXX", in help but I didn´t find anything. Where would I get a functions list?

Thank you one more time BBT.

Fiber9906

[Bill_Britt]

Not sure what you mean. There is a QlikView document install when you install QV call APIguide.qvw.

It is located at C:\Program Files\QlikView\Documentation this is all the API calls.