nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using columns from data table as combo box items?

aparna_shankran

Is it possible to use column names from the data table as items in a combobox in a JMP application?

if so, how do I reference it in the application.

I have sales and quantity sold as two columns. I also have a bar graph

What I want to do is create a combobox with sales and quantity sold as the items. when sales is selected the the bar graph shows the values from the sales and when quantity sold is selected it shows a bar graph with quantity sold?

thanks

Accepted answers

All comments

ian_jmp

It would be more conventional to use column list boxes, but if you do need a combo box then try:

NamesDefaultToHere(1);

// Make a table

dt =

New Table( "Data",

Add Rows( 0 ),

New Column( "sales",

Numeric,

"Continuous",

Format( "Best", 12 ),

Set Values( [] )

New Column( "quantity sold",

Numeric,

"Continuous",

Format( "Best", 12 ),

Set Values( [] )

)

);

// Get the column names in dt into a list

cols = dt << getColumnNames("String");

// Make a UI

nw =

NewWindow("Select a column from "||(dt << getName),

cb = comboBox(cols),

ButtonBox("OK", OKscript)

);

nw << sizeWindow(300, 200);

// Recover the selection from the UI

OKscript =

Expr(

nw << closeWindow;

myCol = cols[cb << get];

Print(myCol);

);

aparna_shankran

I am very new to JMP so please excuse these questions.

My table has 10-15 columns of which sales and quantity sold are two.

How do I reference just these two columns in the combo box, rather than all of them?

also, how do I do it in the application builder? do I have to write the script or is there a way to do it by drag and dropping in the module and then changing the properties.

pmroz

If the columns Sales and Quantity Sold are unchanging, then just hard-code them into a combobox. In Application Builder, drag a combobox into the design area. By default it uses items "Item1" and "Item2". Double-click on Item1 and change it to Sales. Double-click on Item2 and change it to Quantity Sold.

aparna_shankran

got it,thanks. but if I link each item say to a graph, can I do that.

please refer to the original post above.

do I create two graphs and then link it some how to the respective item or is it possible to do just one graph where the y-axis changes according to the item picked in the drop down menu

thanks