topic Re: Detach Table with Macro doesn't work in QlikView

Detach Table with Macro doesn't work

Anonymous — Tue, 28 Jun 2016 12:23:11 GMT

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

Re: Detach Table with Macro doesn't work

Anonymous — Tue, 05 Jul 2016 20:32:14 GMT

I now tried to use Alternate State for the table which I want to unlink but it doesn't work also.

I use the "Layout -> Set Alternate State" function, choose the chart ID (CH135) and an Alternate State (RP_Getrennt) but nothing happens, if I click at the button. Please help me because the browserbased version of QlikView doesn't have the possibility to detach a table.

Thanks in advance.

Re: Detach Table with Macro doesn't work

tamilarasu — Wed, 06 Jul 2016 02:03:47 GMT

Hi Oliver,

Have a look at the attachement.

To Enable Alternat State:

To Disable Alternate State:

Re: Detach Table with Macro doesn't work

Anonymous — Wed, 06 Jul 2016 07:36:08 GMT

Oh no...so easy! And I tried one hour to understand it

Thanks a lot for the quick help, Tamil!

Re: Detach Table with Macro doesn't work

Anonymous — Wed, 06 Jul 2016 15:23:47 GMT

Hm, I tried it out, it worked but the result is different to detaching the table.

I don't really know what happens, when I switched to the Alternate State "RP_unlinked" bute the table then shows other results. The table is the only element which has this Alternate State when I click the Button "Trennen".

After the click, the table shows in the the first column (actual data) the data from the second column (last Year).

Table without Alternate state and the data I expect:

Table with Alternate state:

Sorry, I'm not able to explain it better than I do.

I would prefer to click a button and then detach this table because it works perfect in the desktop version. Perhaps somebody can send me a hint.

Thanks in advance.

Re: Detach Table with Macro doesn't work

tamilarasu — Wed, 06 Jul 2016 17:28:36 GMT

Oliver,

Did you find the value changes in desktop or access point.? I have not tried this in access point. So I have no idea about the mismatch.

Re: Detach Table with Macro doesn't work

Anonymous — Wed, 06 Jul 2016 18:29:56 GMT

Hi Tamil,

I find the change of the values in both versions, desktop and Access Point.

It would be great to know, how I can detach a table with a button - I hope someone can explain how.

Re: Detach Table with Macro doesn't work

tamilarasu — Thu, 07 Jul 2016 05:14:27 GMT

Please share some your application or atleast sample one. It would be easy for us to help further.

Preparing examples for Upload - Reduction and Data Scrambling

Re: Detach Table with Macro doesn't work

Anonymous — Fri, 08 Jul 2016 08:28:28 GMT

Hi Tamil,

thanks for the info. But before I start to prepare the example - isn't it really impossible to detach a table in the browserbased version of QlikView? I think I don't expect to much. Perhaps with a macro or something like that.

That issue is the only problem to launch my application in the hole company!

Thanks in advance.

Re: Detach Table with Macro doesn't work

tamilarasu — Mon, 11 Jul 2016 05:27:24 GMT

Hi Oliver,

I have not tested this macro file in access point. Please test this app in access point and let me know.

Re: Detach Table with Macro doesn't work

Anonymous — Wed, 20 Jul 2016 10:30:00 GMT

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

Re: Detach Table with Macro doesn't work

tamilarasu — Wed, 20 Jul 2016 20:01:47 GMT

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.

Re: Detach Table with Macro doesn't work

Anonymous — Thu, 21 Jul 2016 12:53:13 GMT

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.

Re: Detach Table with Macro doesn't work

tamilarasu — Fri, 22 Jul 2016 02:08:55 GMT

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

Re: Detach Table with Macro doesn't work

Anonymous — Wed, 27 Jul 2016 14:19:06 GMT

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!

Re: Detach Table with Macro doesn't work

tamilarasu — Fri, 29 Jul 2016 02:33:54 GMT

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