Everytime I take sheet it takes a long time to load (up to 20 seconds). I believe this is down to a 2 line macro that fetches the name of a sheet and then selects a field value.
My question is, if I put this on the server, will the macro be sped up. i.e. are macros done locally or on the server? And even if it's done on the server, will this make a difference?
I understand qlikview 9 does actions, but for the moment i'm curious about macros.
Curious in version 8, is there another way to select a field value based on the active sheet name - without using macros?
I don't think there is another way to select a field value "automatically" based on the active sheet name, however, I'm pretty sure there should be another way to achieve the desired business functionality without necessarily selecting a field value.
The problem with macros is that, according to the developers, macros interfere with the multitasking features, and as a result, when you use macros, QlikView is forced into a single-threaded more (I'm probably explaining it technically wrong, but the essence is like that...)
The trick is to try to find the business solution or a work-around and avoid using the macro.
