topic Change object layer value when clicking on it in QlikView

Change object layer value when clicking on it

Miguel_Angel_Baeyens — Fri, 27 Nov 2009 00:50:53 GMT

Hi everyone!

I have some QV documents with several minimzed charts "grouped" with a transparent textbox over them so if you click on the minimized icon you are actually clicking on the textbox, with executes a macro. So far, so good.

Now, some of these charts may be maximized. If I change the layer to "Top" or custom above "1", when the chart is minimized, it won't be possible to "group" under the textbox. If I change the layer to Top in the textboxes, when maximized, the chart will be under those textboxes.

I was trying to find out how to change possible layer values with a macro, but I don't know how to do it.

Any ideas or suggestions will be appreciated!

Change object layer value when clicking on it

Fri, 27 Nov 2009 01:44:58 GMT

The query is not clear...:(
Why do you need to place a transparent text box on top of the charts?
If that triggers a macro, then it must be a button and not a tect box.

Can you please ellaborate you query brother?

Change object layer value when clicking on it

Fri, 27 Nov 2009 12:51:19 GMT

try if you can incorporate this in you rmacro

ActiveDocument.GetSheetObject("CH01").SetLayer 1

parameters are

-1 bottom

0 normal

1 top

regards

peter

Change object layer value when clicking on it

Miguel_Angel_Baeyens — Fri, 27 Nov 2009 16:15:35 GMT

Thanks Peter, that was I was looking for.