Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have a question about the activation of a macro:
Can you attach a macro to a cycling group in a table?
so that when changing the dimensions of cycling group macro is activated.
Thanks
You can trigger the macro indirectly by detecting OnChange of a variable defined as:
=GetCurrentField(myGroup)
See attached example.
-Rob
There isn't an Event that would be triggered when a group is cycled. So basically, no.
You may be able to use some combination of OnActivate and the API to determine when a Cycle group has been changed and when it does change, perform your required actions. I haven't had a lot of success using OnActivate for things like this. There was a discussion on something similar, where the user wanted an OnMinimize event. I tried to use OnActivate and IsMinimized to simulate that Event, but it did not go smoothly.
Another option, is to use a button to do the actual cycling and run your cycling macro at the same time. This is probably easier to implement, as long as you can convince your users to use the button, rather than the built cycle button.
You can trigger the macro indirectly by detecting OnChange of a variable defined as:
=GetCurrentField(myGroup)
See attached example.
-Rob
Great Rob!!!!
Works perfectly.
Thanks
Rob
I downloaded your document, When i closing the document i am getting error. Attached the error message. I opened and closed three times, each time getting the same error. I won't get any error for other reports.
Thanks,
Raghu.
Works perfectly for me when i open the document and when i close.
Which Version of qlikView uses?
I have installed V 8.50 and V 9.0. Am getting error only at version 8.5 not on V 9.0
Don't know why its happening in V8.50?
-Raghu
I don't know the cause of the problem with that version.
I have installed the version 8.50.6261 and the problem does not appear.
If you want to use the 8.50 version install 8.50.6261 and try to close the document.
-FV-
Raghu wrote:Am getting error only at version 8.5 not on V 9.0
Raghu,
I have no idea what the problem might be. It works fine for me on 8.50.6206 & 6299. It's a very simple document.
Have you tried downloading it again?
-Rob
-Rob
My exact version is V 8.50.6091.4. I have created a new qlik document with exactly what you did. Same error comes when closing the document.
good work Rob.
-Raghu.