topic Re: Macros not working with plugin in QlikView

Macros not working with plugin

devans_1 — Thu, 03 Apr 2014 11:20:51 GMT

Hi experts....

I am having problems running simple macros using the IE plugin. There are only a few small macros - a couple are used to create/apply bookmarks and a couple are used to toggle list boxes 'Always select one value' on and off. All works fine until accessed from the access point using the plugin. No macro then works. I have tried allowing 'System access' and 'Allow safe access' but this makes no difference. And from the QMC, the 'Allow macro execution on server' is ticked. I have also tried ticking 'Allow unsafe macro execution on server' but this makes no difference. QlikView does not give an error but the macros fail. I am using v10. Does anybody have any idea what is wrong ? I am hoping it is something simple

Re: Macros not working with plugin

srchilukoori — Thu, 03 Apr 2014 14:13:01 GMT

Please attach a sample app.

Re: Macros not working with plugin

sivarajs — Thu, 03 Apr 2014 14:34:04 GMT

check ctrl+shift+M in access point has system access . If yes, check your macro using some msgbox("ok") in between macro just to make sure your code is working

Re: Macros not working with plugin

devans_1 — Fri, 11 Apr 2014 14:26:42 GMT

Thanks for the comments Sivaraj. The ctrl+shift+M is particuarly helpful. I think the cause of my problem was having several of my list boxes as 'Always one value' which I want when a user is in a sheet but I also want to 'hide' them when they move to another sheet. So I was using a macro to remove the 'Always one value' followed by a clearing of the value when the user changes sheet. Seems the macro for 'Always One Value' does not work with plugin. I have got round this by always having the objects as allowing multiple/none values but having a trigger on the object - something like.

if (mid (GetActiveSheetId (), 12, 2) = '01',
if (isnull ([<field>]),
only ({$1} [<field>]),
only ([<fielld>)),
' ')

This emultate 'Always one value' quite well. So problem solved (more or less).