topic Need help with macros in QlikView

Need help with macros

stevietm — Wed, 19 Feb 2014 13:18:27 GMT

Hi All,

Please visit the below link as i need some help with this. I do not know what i am doing wrong.

Thanks

http://community.qlik.com/thread/107915

Regards

Stevie

Re: Need help with macros

marcus_sommer — Wed, 19 Feb 2014 13:51:59 GMT

What happens if you execute this macro - nothing or is there an error message? Especially if the code will separate executed - it is always recommended to split (easiest way through comments) code to minimize potentially errors.

Which client do you use? Within AJAX none macros will work.

Perhaps it is better to use the id from bookmark. Also it could be that this bookmark is an user-bookmark. See here for examples from the APIGuide.qvw (is within your install-folder) and really recommended by using macros.

ActiveDocument.RecallDocBookmarkByID "BM01"

ActiveDocument.RecallUserBookmark "MyBookmark"

Further I didn't understand the order from code: firstly you called the bookmark and then before exporting you cleared all selections ... Also the locking from fields could be cause issues.

- Marcus

Re: Need help with macros

stevietm — Thu, 20 Feb 2014 06:41:08 GMT

Hi Marcus,

Please have a look at my link again as i updated the scrips. This is my first time working with macros.

Thanks

Regards

Stevie