Subscribe Bookmark RSS Feed

from column dialog list to variability chart

h_lazar

Community Trekker

Joined:

Jun 23, 2011

This seems like such a simple thing but for the life of me I can not seem to make it work.

I have a table with numerous columns. I ask the user to choose columns through a column dialog for the X factors in a variability chart. Then I want to plot all of the other columns versus those factors. The problem I am having is that the result of a column dialog is a list of column names, not strings but actual name references. I can not seem to figure out how to use that variable in the variability chart syntax. Do I need to make it into a string? Do I need to evaluate an expression? I would love some help.

Clear Symbols();

dt0 = Current Data Table();

//choose column for plotting

r_coldlg = Column Dialog( col_id = Col List( "X , Factor" ) );

ls_factor= r_coldlg["col_id"];

//for each column (in this example, columns 12-14

For( i =12, i <= 14, i++,

  r_var = Variability Chart( Y( Column( dt0, i ) ), X(ls_factor) );

);

thanks

Heather

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Try to put the X-list inside Eval().

r_var = Variability Chart( Y( Column( dt0, i ) ), X( Eval( ls_factor ) ) );

2 REPLIES
Solution

Try to put the X-list inside Eval().

r_var = Variability Chart( Y( Column( dt0, i ) ), X( Eval( ls_factor ) ) );

h_lazar

Community Trekker

Joined:

Jun 23, 2011

Yes that worked. I had tried Eval List () because I thought it was a list. I never thought to try Eval() alone. I wish I understood the difference but I am happy enough for now.

thanks

H