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]

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.

[tamilarasu · Accepted solution]

Hi Oliver,

Have a look at the attachement.

To Enable Alternat State:

To Disable Alternate State:

[Anonymous]

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

Thanks a lot for the quick help, Tamil!

[Anonymous]

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.

[tamilarasu]

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.

[Anonymous]

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.

[tamilarasu]

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

[Anonymous]

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.

[tamilarasu]

Hi Oliver,

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