topic Re: Closing data tables but keeping plot results in Discussions

Closing data tables but keeping plot results

Anonymous — Wed, 25 Jul 2012 12:05:11 GMT

Hi,

I have written JMP script to manipulate some data tables and produce graphs all on the one window. Part of this involved creating subsets. Therefore i have alot of tables open. I know how to hide them but understand this still uses alot of JMP memory. Therefore i want to close them. However when i close them i lose my plots.

How do i keep my window showing all of the plots?

Re: Closing data tables but keeping plot results

gbu — Wed, 25 Jul 2012 14:02:34 GMT

Hi,

I've not the answer but I'm intersting to know how you can hide tables.
Thanks in advance.

Ragards,

Guillaume

Re: Closing data tables but keeping plot results

Anonymous — Wed, 25 Jul 2012 14:09:46 GMT

Hi,

to hide a table you just have to put in the word "invisible".

dt = Open("SAMPLE_DATA/Big Class.jmp", invisible);

Re: Closing data tables but keeping plot results

gbu — Thu, 26 Jul 2012 08:14:43 GMT

Thanks, good to know but it don't works with OpenDataBase() command.

Re: Closing data tables but keeping plot results

Anonymous — Thu, 26 Jul 2012 08:17:53 GMT

I had a similar issue so I used the following code to get around that:

my_file = pick file();

dt = open(my_file,invisible);

Maybe that will work for you too.

Re: Closing data tables but keeping plot results

Anonymous — Fri, 27 Jul 2012 08:50:44 GMT

Can anybody offer some help with this? All I want at the end of running my script is a window showing various plots. I don't care about the data tables.

Is there a command to freeze the plots so if i close the data tables, I won't lose my plots?

Re: Closing data tables but keeping plot results

mpb — Fri, 27 Jul 2012 13:50:01 GMT

Have you tried sending each plot to a journal as you make it? When done with a table, close it and the platform output. The journal will remain and you can keep adding to it with the next bunch of plots.

Re: Closing data tables but keeping plot results

Anonymous — Fri, 27 Jul 2012 14:09:58 GMT

Hi mpb,

I tried using a journal previously and it worked well.

However when it is in a journal - you have less flexibility with graphs. The red triangle menu gives very little options compared to when the graph is in a window.

The window menu would give the user far more flexibility for customizing the plots. Such as adding quantiles, summary statistics, etc.

Thanks for your help.

Re: Closing data tables but keeping plot results

wiebepo — Tue, 31 Jul 2012 03:39:20 GMT

Consider the following sequence:

1.retrieve data

2.make invisible copy

3.close original data table

4.create graphs

5.add a function to one graph to close the invisible table when it is closed.

Something like as follows:

dt_original=opendatabase(parameters);

dt=dt_original<<subset(rows(),invisible);

close(dt_original,nosave);

plot_graph=dt<<graphbuilder(parameters);

plot_graph<< Subscribe("Close Invisible table", On Close( close(dt,nosave) ) );

Re: Closing data tables but keeping plot results

Anonymous — Tue, 31 Jul 2012 08:51:17 GMT

Thanks very much weibepo.

I adapted your code above so that now when i close my Report Window all hidden data tables close too.

nw << On Close(close all(Data Tables, NoSave));

where nw is my report window.

Re: Closing data tables but keeping plot results

djhanson — Fri, 03 Aug 2012 15:11:34 GMT

Make your chart using its individual display box object(s). That way, when you close your data table, the chart will still display.

Normally, when you close a data table to a canned (linked) JMP chart, the chart disappears of course. But by making the chart composed of its individual object(s) via its report, it will still display after closing the data table. Here's roughly how to do this below, you will want to find your exact chart object references using Show Tree Structure (e.g. PictureBox, etc, etc). Finally, you will likely need to append it into your original window reference, which I do not show below. cheers... dj

myVar = Bivariate(

Y(:YVALUE),

X(:XVALUE)

);

myVarR = myVar<<report;

<<append(myVarR[PictureBox(1)]);