topic Basic Question on Bookmark in QlikView

Basic Question on Bookmark

Mon, 03 Oct 2011 18:41:31 GMT

Hello,

I have a very basic requirement of dislaying bookmark name in a text box (if there is an active book mark selection).

Is there any out of box variable/function can be used to display this? or is there any way to achive this?

Thanks,

Aji Paul.

Basic Question on Bookmark

Tue, 04 Oct 2011 12:31:55 GMT

Hi this is a macro to pick tha name (copied from ApiGuide.qvw):

set bm = ActiveDocument.GetBookmark("BM01")

if bm.Default = true then

msgbox(bm.Bookmark.Name)

else

msgbox("Bookmark does not exist")

end if

But You have to get a target bookmark...

Try to search in ApiGuide.qvw if there is a way to discover the bookmark selected...

C u,

Stefano.

Basic Question on Bookmark

Tue, 04 Oct 2011 15:43:56 GMT

Stefano,

Thanks for the direction.

I never used any API with QV(just getting hands around QV).

BTW where do I try this code. As textbox properties?

Basic Question on Bookmark

Miguel_Angel_Baeyens — Tue, 04 Oct 2011 15:47:50 GMT

Hi,

There is a Module editor in QlikView in addition to the Script editor that you already know. Go to Control + M to use the QlikView API and VBScript or JScript code according to the APIGuide.qvw file syntax. This file is located in the Documentation folder if you do the complete instalation.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Basic Question on Bookmark

Tue, 04 Oct 2011 16:10:02 GMT

Thanks Miguel!

Pardon my unawareness! What are some practical application of APIs?

Can APIs be used in the following scenario? When a book mark is selected,navigate to a specific sheet.

(I am still waiting for the approval of QV training from my employer)

Basic Question on Bookmark

Miguel_Angel_Baeyens — Tue, 04 Oct 2011 16:21:32 GMT

Hi Aji,

No problem, this is what the QlikCommunity is for.

In regards to your particular question, there is no need for a macro. When you create a bookmark, make sure you click "Include Layout State" and you will get to the same point of selections, scroll in charts and same sheet where you created it. So first of all, go to the sheet you want to be moved, and there create the bookmark.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Basic Question on Bookmark

Tue, 04 Oct 2011 18:44:44 GMT

Thank You Miguel! That helps a lot!

BTW what are the typical uses of these APIs?

Re: Basic Question on Bookmark

jonathandienst — Tue, 04 Oct 2011 20:22:07 GMT

Aji

I have a fully documented process for displaying the active bookmark from a set of bookmark at my blog. This is how it displays (its a list box). This process does not require macro code, only a little setup and a couple of actions.

Have a look at the blog article here.

I would be happy to answer any questions you may have if you get stuck.

Regards

Jonathan

Re: Basic Question on Bookmark

Tue, 04 Oct 2011 20:53:54 GMT

Thanks Jonathan! Very interesting!

My plan was creating few bookmarks on a sheet, then excutive can select the bookmark and it will update a text box with the bookmark name. So it will serve as a report title

Re: Basic Question on Bookmark

jonathandienst — Wed, 05 Oct 2011 10:15:03 GMT

Aji

If you use my approach, then the report title could be dynamic, like this:

=GetFieldSelections(BMName)

(assuming only one bookmark name selected)

Regards

Jonathan

Re: Basic Question on Bookmark

Wed, 05 Oct 2011 17:10:05 GMT

Thank You Jonathan!

Awesome suggestion!

BTW I did add another field BMLongDesc to the inline load and used that as title. I needed a long detailed title.

LOAD * INLINE

[

BMName, BMId, BMLongDesc

DVD, BM01, Customers who bought DVD

BOOK, BM02, Customers who bought Book

];

then added textfield expression as =BMLongDesc

will publish the qvw soon

Re: Basic Question on Bookmark

Wed, 05 Oct 2011 19:11:04 GMT

I have uploaded a QVW waiting for moderator

Re: Basic Question on Bookmark

dapostolopoylos — Fri, 15 May 2020 11:11:42 GMT

@jonathandienst It's a blast from the past for you but for me this is just what i needed!

Thanks a lot! 🙂