<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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
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
Try to put the X-list inside Eval().
r_var = Variability Chart( Y( Column( dt0, i ) ), X( Eval( ls_factor ) ) );