topic Message when activating sheet in QlikView

Message when activating sheet

guyvermeiren — Thu, 26 Aug 2010 15:12:48 GMT

Hello,

I would like a message (or alert) showing up every time I activate a certain sheet in my application.

Is this possible.

Thanks,

Guy

Message when activating sheet

Thu, 26 Aug 2010 15:29:23 GMT

properties in your sheet -> Triggers -> On activet sheet Add action...External ->Run Macro

in your Macro just put something like MSGBOX('Your message!!')

Message when activating sheet

guyvermeiren — Thu, 26 Aug 2010 16:39:10 GMT

Thanks Érico,

When I test this in the macro itself it works, but when I activate the sheet nothing happens. Do I have to add something else in my actions ?

Guy

Message when activating sheet

montubhardwaj — Thu, 26 Aug 2010 18:04:53 GMT

Hi Guy,

I think you need to trigger the above Macro for the particular sheet.For example, If you want the message to apper on 2nd sheet, Trigger the macro for sheet 2.

REgards,

Sharma

Message when activating sheet

Thu, 26 Aug 2010 18:30:01 GMT

Nothing....look my example....

if still same doubt tell me!!!![View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6332.example.zip:550:0]!

Message when activating sheet

Thu, 26 Aug 2010 18:31:58 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/2703.example.zip:550:0]

Message when activating sheet

montubhardwaj — Thu, 26 Aug 2010 19:02:02 GMT

In 8.5, I will do something like this,

Write a macro as below:

SUB test

msgbox("Hello")

END SUB

Then go to

Settings-->Document Properties-->Sheets and choose the sheet where you want the message to appear and click on Properties --> Macro and Select your Macro.

Hope this was helpful.

Regards,

Sharma

Message when activating sheet

Thu, 26 Aug 2010 19:14:57 GMT

Maybe have something different on 8.5 version....

I never worked with that version.....anyone can help!!!

Sorry Sharma!!!

Message when activating sheet

guyvermeiren — Fri, 27 Aug 2010 07:41:54 GMT

Érico,

I checked your example and did the same in my application, this works perfect.

Thanks to all repliers,

Guy