Detach Table with Macro doesn't work

[Anonymous]

Hallo,

because we now use QlikView browserbased an because the function "Detach" seems to be not available in Browser, I have to find a way to detach and attach tables via Button.

Yes, I used the search function and found some threads about this issue. Most of the answers where like "use a macro like this"

Sub DetachTable 
ActiveDocument.GetSheetObject("CH135").Detach 
End Sub

We use QlikView 11.20 and this way doesn't work - nothing happens after the button is clicked.

Can someone of you help me please? Thanks in advance.

Oliver

[Anonymous]

Hi Tamil,

sorry for the delayed answer.

Thank you for the macro which worked well in the desktop version and does nothing in the Access Point.

I could cry!

Any ideas?

Thanks a lot

Oli

[tamilarasu]

Hi Oliver,

I have attached a two files below. one is work around and another one is again alternate state. I believe, alternate state solution should work in access point as well. I hope there is no harm in testing the sample application once again to confirm the result. Test both the applications in desktop and access point. If it works, apply the same logic in your original app and test again. Kindly let me know the results.

[Anonymous]

Hey Tamil,

thanks for your patience!

I tried both, but the workaround doesn't work at the Access Point and the Alternate State switches my values after clicking "Detach".  It seems, that I'm not able to find a way/my mistake.

So I shrinked my Application down - perhaps you can have a look at it.

[tamilarasu]

Oliver.

Now, I understood your requirment.   You need to use macros in this case. There are many reasons where the macros not work in access point. Hope you are using IE as browser and not chrome. The ajax client does not support some macro's (but if you are using AJAX just give a try).

I think you need to enable macros in server settings. Please read the below links and make sure all the procedures followed.

macros not working on server

Macro not running in access point

Is possible make macros that run server-side? | QlikView Help, Tips & Hints

[Anonymous]

WOOOOOHOOOOOOOOOOO - it works!!!

Thanks SO much for your patience with a Newbie like me - that was the point!

If you ever will come to the south of germany near Freiburg - let me know...you get not only one drink for free!

[tamilarasu]

Great. Finally we did it!!. I am going to start my day with your kind words.Thank you, Oliver.