Macro execution creating loss of focus/control from elements
I'm using following statements in my Macro definition:
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.GetApplication.Refresh
As soon as my Macro runs, I loose the control over all the elements in QlikView and it no longer remains possible to get the control back until the Macro as completed it's task. For example, if I'm running a loop 1000 times within a Macro but I don't want to loose focus from all the Qlikview elements till the loop is done with the execution of 1000 instructions.
Hi, when macro is running, you do not have control for the objects in document, you will have to wait to finish the loop (finish the exec of the macro)
I'm curios to know if my problem can be solved using a different method. I'm using macro to run multiple chart animations on a button click. I have added the 'Run Macro' as the action of button. In the Macro definition, I have a loop which goes over all the possible values of a field (say fieldA). So as the new value of fieldA is selected while moving in the loop, corresponding values in the charts are reflected. So, with change in field values in the loop, a change in every chart value is also reflected so as to give the intuition of animation.
Problem I'm facing is: I can't find a way to pause such an animation because Macro keeps on executing until loop has ended. So, is there a way to achieve this Pause functionality? I am also open for any other suggestion for building Multiple Chart Animations if you think doing it using Macro is not a good idea.
I understand what you are doing using macro, and it is a good way to simulate animation in objects.
One think coudl be limitated the object animation by page, not loop for every object in the object, only in the page where the user is, for example when the user run macro button, the animation only happend in all the objects in the page that the user is seeing.
the time would be less because you dont have to wait for all the object in all the document.
another point using this, could be that you are loss the flexibility of qlikview, because one advantage of qlikview is the discovery, the fix of dimension, clink and unclik , using this kind of macro you will lost it, because you combine automatically all with all and you dont give the possibility to the user to create her own WORLD of data and test different combination of information.
pherhaps you will have to find the way that the animation do not affect to all the document(unless you have to do it of this way )
