topic Re: Macro wont activate on app opening in QlikView

Macro wont activate on app opening

Thu, 18 May 2017 11:05:29 GMT

hi guys

i have a macro that change the selection color but it only active when i run it from ctrl+m

but i need to run it each time the app is opened

so i made a trigger that would run it "onopen"

but it doesn't seem to work like in the picture i tried to call it using name+() or just name

but it doesn't seem to work

any help would be appreciated

Re: Macro wont activate on app opening

Thu, 18 May 2017 11:24:40 GMT

mohammed.prog‌

Re: Macro wont activate on app opening

Peter_Cammaert — Thu, 18 May 2017 16:00:14 GMT

Where do you open your "app"? In QV Desktop or in an AccessPoint client?

Re: Macro wont activate on app opening

Thu, 18 May 2017 16:46:20 GMT

i tried on both

Re: Macro wont activate on app opening

Peter_Cammaert — Fri, 19 May 2017 07:37:26 GMT

Macros that try to manipulate the UI won't work in the Ajax Client.

Re: Macro wont activate on app opening

tamilarasu — Fri, 19 May 2017 09:08:49 GMT

Hi Ahmed,

Could you remove the round brackets in the trigger and try?

Re: Macro wont activate on app opening

Sun, 21 May 2017 07:24:09 GMT

already tried also and nothing happens

Re: Macro wont activate on app opening

tamilarasu — Sun, 21 May 2017 07:36:10 GMT

Below attached file is working fine in my QlikView version 12.

Re: Macro wont activate on app opening

Sun, 21 May 2017 08:04:31 GMT

Thanks Tamil i put your Msgbox code inside my Sub and it actually runs but that it the rest of the code doesn't work
maybe it's just as @Peter said above "Macros that try to manipulate the UI won't work in the Ajax Client."

Re: Macro wont activate on app opening

Sun, 21 May 2017 08:05:40 GMT

so is there away to work around it

Re: Macro wont activate on app opening

tamilarasu — Sun, 21 May 2017 08:10:09 GMT

Hi Ahmed,

Yes I think so. I haven't tried but I heard that Macros are not working in AJAX client. So you have to find out workaround.

Re: Macro wont activate on app opening

Peter_Cammaert — Sun, 21 May 2017 10:47:29 GMT

I'm not a fan of changing the selection color scheme (except for device-related reasons). There are however a few tricks that may be of use to you:

You can choose one of the other color schemes in Settings->Document Properties->General->Seleciton Appearance->Color Scheme.
The macro you are trying to run is lifted from a recipe in a Stephen Redmond book. In it, he explains what this macro actually does: it stores the color settings in the Settings.ini file in your profile. You can refer to these color settings by selecting the [Custom] scheme in Document Properties list. However, they will only apply to the current user, and AFAIK the colors themselves won't travel with your document.
Finally, you can change the selection colors scheme on a server by adding the color settings from the Settings.ini file in your profile to the QlikView Server Settings.ini file. See here for the details.Changing default colors of QlikView Note that this scheme will apply to ALL documents published on your server. Which is to be expected, as it would be extremely confusing if these basic colors would be different in every other document.

As I said before, I'm not a fan of changing the selection color scheme. Compare this to every country selecting their own set of colors for traffic lights. Or even better, rotating them...

Best,

Peter

Re: Macro wont activate on app opening

swuehl — Sun, 21 May 2017 10:52:45 GMT

Maybe a document extension can do what you want.

http://www.qlikfix.com/2012/05/18/any-colour-as-long-as-its-green/