topic AW:Re: macro button in QlikView

macro button

Mon, 10 Jan 2011 13:38:56 GMT

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

macro button

Mon, 10 Jan 2011 13:46:21 GMT

Hi,

when you create a button see the action sheet and clik on ADD, there is the bookmark session where you can apply, create or replace a Bookmark.

macro button

Mon, 10 Jan 2011 14:00:23 GMT

Hi Luca,

I´m sorry but I don´t see what you are trying to say me. Which tab are you using? On generaI tab, I´ve got three options: launch, shortcut and Macro and the options showned depends on what you´ve got marked.

Could you explain me more?

Thank you, Fiber9906

macro button

Mon, 10 Jan 2011 14:17:48 GMT

I hope that this is what you need.

AW:Re: macro button

Hatus — Mon, 10 Jan 2011 14:19:48 GMT

Click with the Right button on the button -> Properties -> choose tab "Actions" -> Below the with window click on Add -> Bookmark -> Then choose what you want to do with your bookmark, just give its ID.

Regards

macro button

Bill_Britt — Mon, 10 Jan 2011 14:21:47 GMT

If you look at the properties of the Button and the action tab. You will find it there.

macro button

Mon, 10 Jan 2011 16:21:49 GMT

Wow!! thank you Luca. It´s very very easy, but I don´t have this tab. In general tab I´ve got launch/export, or shortcut or Macro, and depending which function is selected, it changes tabs. These are three options I can see, but never Actions. Should I do anything to activate this option?

Thanks!!

macro button

Bill_Britt — Mon, 10 Jan 2011 16:29:37 GMT

What version of QlikView are you running?

macro button

Mon, 10 Jan 2011 16:32:08 GMT

8.5

macro button

Bill_Britt — Mon, 10 Jan 2011 16:37:57 GMT

Ok, that explains why you don't have the options. You can assign a macro to run from a button and you can apply the bookmark with a macro. I will have to install version 8.5 to write the macro. So stay tuned.

macro button

Mon, 10 Jan 2011 16:43:30 GMT

I really appreciate your help. Thank you.

Just curiosity, which is the version you running?

Fiber9906

macro button

Bill_Britt — Mon, 10 Jan 2011 17:29:01 GMT

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]

macro button

Mon, 10 Jan 2011 18:50:29 GMT

Very good answer!! It works perfectly!!

Lots of thanks!!

Fiber9906

macro button

Mon, 10 Jan 2011 19:05:15 GMT

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

macro button

Bill_Britt — Mon, 10 Jan 2011 20:12:19 GMT

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.