topic Re: Macro for Saving Active selections in Bookmark object in QlikView

Macro for Saving Active selections in Bookmark object

pavanthota — Mon, 04 Mar 2013 14:53:36 GMT

Hi,

I have to create a macro which creates bookmark object saving the selections made in the QlikView document.

Can anyone help me on this macro

Thanks,

Pavan

Gysbert_Wassenaar — Mon, 04 Mar 2013 15:27:44 GMT

Sub AddBookMark

ActiveDocument.CreateDocBookmark false, "MyBookmark"

End Sub

pavanthota — Tue, 05 Mar 2013 07:18:41 GMT

Hi Wassenaar,

Thanks for your reply

Not only creation of book mark whatever the selections exist in QlikView document, those selection i want to save it in Bookmark through macro

Regards,

Pavan

Thu, 07 Mar 2013 10:53:25 GMT

Hi Pavan,

See if this below code helps you

SUB GetSelectedValues

ActiveDocument.RemoveUserBookmark "savecurrentselection"
ActiveDocument.CreateUserBookmark "savecurrentselection"
ActiveDocument.ClearAll

END SUB

SUB RecallSelectedValues

ActiveDocument.RecallUserBookmark "savecurrentselection"
ActiveDocument.RemoveUserBookmark "savecurrentselection"

END SUB

Thanks,

Sarathi