How to Use a Variable for Custom Value Order in JMP Scripting?

mysteriouskrypt — Thu, 28 Aug 2025 20:33:39 GMT

Hi everyone,

I'm trying to set a custom value order in a column using JSL. Here's the code that works when I hardcode the list:

TestTable:Origin << Set Property(
"Value Order",
{Custom Order({"EU", "IND", "US", "JPN", "AU"}), Common Order(0)}
);

However, when I try to pass the list as a variable, it doesn't work:

countriesOrder = {"EU", "IND", "US", "JPN", "AU"};
TestTable:Origin << Set Property(
"Value Order",
{Custom Order(countriesOrder), Common Order(0)}
);

My goal is to read the country order from an Excel file and use that list dynamically. But I can't find documentation on what Custom Order() accepts—whether it can take a variable or only a literal list.

Re: How to Use a Variable for Custom Value Order in JMP Scripting?

txnelson — Thu, 28 Aug 2025 21:57:36 GMT

A variable within a JMP list will not be evaluated unless forced. Try this

countriesOrder = {"EU", "IND", "US", "JPN", "AU"};
Eval(
	Eval Expr(
		TestTable:Origin << Set Property(
			"Value Order",
			{Custom Order( Expr( countriesOrder ) ), Common Order( 0 )}
		)
	)
);

topic How to Use a Variable for Custom Value Order in JMP Scripting? in Discussions

How to Use a Variable for Custom Value Order in JMP Scripting?

Re: How to Use a Variable for Custom Value Order in JMP Scripting?