topic Re: Disassociate a table after importing data in QlikView

Disassociate a table after importing data

Mon, 19 Nov 2012 15:14:16 GMT

Hi there,

i have a dashboard that reads 9 different excel spreadsheets and what i need is to disassociate (in italian version: "sconnetti logicamente" - logically disconnect) a straight table, in order that the values inside this table do not change during the data analysis.

I need this because they represent the % Effort of each team on all the services offered to customer.

Here is a screenshot also:

Is it possible to insert a code inside the Script to let this table to get "disassociated"/"disconnected logically" just after the ending of data loading?

Re: Disassociate a table after importing data

Gysbert_Wassenaar — Mon, 19 Nov 2012 15:22:40 GMT

Detach the table by checking the Detached option on the General tab of the properties screen. This can not be done from the load script, but you could set a variable in the load script and have a macro run on the OnPostReload trigger to set the Detached value. Something like:

sub DetachMyChart

set v = ActiveDocument.Variables("vDetachCH01")

if v.GetContent.String = 1 then ActiveDocument.GetSheetObject("CH01").Detach

end sub

Re: Disassociate a table after importing data

vgutkovsky — Mon, 19 Nov 2012 15:41:53 GMT

Gysbert,

I respectfully disagree with your approach. While it would definitely work, this is not an elegant way to approach the problem. A much better approach would use set analysis in the chart expressions--either the {1} set or creating a new alternate state group under Document Properties.

Regards,

Vlad