topic Re: How to trigger a macro on every tab selection in a container in QlikView

How to trigger a macro on every tab selection in a container

murozel76 — Tue, 25 Sep 2012 06:33:19 GMT

Hello All,

I have a container with 6 tabs and a number of buttons on a sheet. I have written a macro so that some of the buttons will be disabled/enabled depending on the active tab of the container. The macro works fine, however I couldn't yet find a way to make it run automatically when the active tab of the container changes i.e. on every change of the "SingleObjectActiveIndex" value of the container. Is it possible to have a trigger like this? Otherwise, I will need another button to run the macro and it should be used after each time the user changes the active tab in the container, which would be no good practice, IMO.

Any help appreciated.

Thank you in advance.

Regards,

sub ButtonStatus

set MV_ContainerObj = ActiveDocument.GetSheetObject("CT13")
Set MV_ContProp = MV_ContainerObj.GetProperties
MV_ActiveIndex = MV_ContProp.SingleObjectActiveIndex

set MV_Button = ActiveDocument.GetSheetObject("BU113")
set MV_ButtonProp = MV_Button.GetProperties

set v = ActiveDocument.Variables("vCT13ActiveIndex")
v.SetContent MV_ActiveIndex,true (Note: I use This document variable [vCT13ActiveIndex] in the "enable condition" of the relevant button)

End Sub

Re: How to trigger a macro on every tab selection in a container

jonathandienst — Tue, 25 Sep 2012 06:56:28 GMT

There is no trigger for container selection changes, so as far as I know there is no way of firing your macro simply by changing the container selection.

You could use a manual action , but I agree that it is not a very good approach. Another alternative is to set the container tabs to drop down and overlay buttons in place of the container tabs. The buttons should select the appropriate tab and control the active state of the other buttons on the sheet.

This is a screenshot of what I mean:

I don't have a script for changing container tabs in a macro, but I am sure that you can find that in the forum.

Hope that helps

Jonathan

Re: How to trigger a macro on every tab selection in a container

murozel76 — Tue, 25 Sep 2012 08:24:10 GMT

Thank you very much, Jonathan. I followed your advice and also managed to change the selected tab in a container via macro.

Anyway, we would be much better off if Qliktech added "trigger" functionality to all sheet objects and container tabs!

Best regards,

Re: How to trigger a macro on every tab selection in a container

jonathandienst — Tue, 25 Sep 2012 14:37:34 GMT

murozel76 wrote:
Anyway, we would be much better off if Qliktech added "trigger" functionality to all sheet objects and container tabs!

Agreed!