topic Macro on table in QlikView

Macro on table

filippo — Fri, 19 Jun 2009 21:56:37 GMT

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

Macro on table

Fri, 19 Jun 2009 22:06:07 GMT

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.

Macro on table

rwunderlich — Sat, 20 Jun 2009 01:04:06 GMT

You can trigger the macro indirectly by detecting OnChange of a variable defined as:

=GetCurrentField(myGroup)

See attached example.

-Rob

Macro on table

filippo — Mon, 22 Jun 2009 14:56:33 GMT

Great Rob!!!!

Works perfectly.

Thanks

Macro on table

Mon, 22 Jun 2009 19:03:20 GMT

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.

Macro on table

filippo — Mon, 22 Jun 2009 19:51:16 GMT

Works perfectly for me when i open the document and when i close.

Which Version of qlikView uses?

Macro on table

Mon, 22 Jun 2009 20:27:05 GMT

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

Macro on table

filippo — Mon, 22 Jun 2009 20:49:31 GMT

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-

Macro on table

rwunderlich — Tue, 23 Jun 2009 00:49:56 GMT


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

Macro on table

Tue, 23 Jun 2009 11:56:55 GMT

-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.

Macro on table

separerl — Wed, 28 Jul 2010 23:06:52 GMT

I downloaded Robs sample , but in my case , the Macro is never fired , the msgbox never appears.
It changes the text object , but it never runs the Macro.

Any ideas ?

Best regards
Pär

Macro on table

Thu, 29 Jul 2010 14:13:30 GMT

Hello Rob,

I have a chart with fast change (Straight and Pivot) which is created dynamically. It contains many dimensions and one of them is a cyclic group which displays field (Date and Month-Year) . This chart is linked to a macro so that when users adds or removes dimensions it returns the number of row count.

Issue: When switching from Month-Year to Date in cyclic group, I cannot find a way to trigger the macro to run that does the row count.

Attached you will find my sample application.

Any suggestions will be appreciated.