Welcome to the JMP User Community!

Latest Discussions

• Failed to convert varchar value ro datatype int in query (query worked before but now not)

  Hi , I used JMP DATAbase Query to query data from tables. the same query worked find until today it suddenly complains of issue of converting char to int. I'm not sure why it worked before and nothing has changed, but now not it is not working. So I started to work on the custom query to find a way to add script to convert. This is my first time with the custom sql query. how can I convert the t2....

  dadawasozo

  Discussions |

  Jun 9, 2023 7:30 AM

  846 views | 0 replies

• How to handle unchecking a checkbox error?

  I want the user to select only one item using the following e.g. Names Default To Here( 1 ); New Window( "Example", cb = Check Box( {"Max", "Median", "Min", "Mean", "Std Dev"}, returned = (cb << Get Selected ())[1]; Print( returned ) //{"Mean", "Std Dev"} or etc ) ); The above works, but if the user checks and then unchecks the checked box, JMP throws an error as it can no longer execute  ...

  Neo

  Discussions |

  Jun 9, 2023 5:43 AM

  1307 views | 1 replies

• How to tell if an optional argument that could be an Associative Array is missing

  As noted in the title, if I have a function that takes some argument that could be an Associative Array:   someFunc = Function( {arg1}, [...] )   And the argument is optional, how to I check `Is Missing`? When I try to use Is Missing in cases where the value does turn out to be an Associative Array I get the error "argument should be numeric in access or evaluation of 'Is Missing' , Is Missing/*##...

  mat-ski

  Discussions |

  Jun 8, 2023 2:35 PM

  1222 views | 1 replies

• Extracting control limits from column info

  I am trying to extract control limits from column info, I have used the below code to extract spec limits, but if I do the same for control limits, it does not work because it treats everything as one element in the list. p = c << get property( "Spec Limits" );
  plst = Eval List( {Arg( p, 1 ), Arg( p, 2 ), Arg( p, 3 )} ); Any ideas? Thanks!

  Abby_Collins14

  Discussions |

  Jun 8, 2023 2:21 PM

  1526 views | 3 replies

• Help with formula: Calculating change relative to an initial timepoints for multiple samples

  Hello All, I am somewhat new to making conditional formulas in JMP and am having some difficulty with this one.  I will be collecting data at specific timepoints for multiple different samples.  Each sample has a corresponding value for the initial (T=0) timepoint and I would like to have a column for the %difference at a given timepoint relative to T=0.  The table will include multiple replicates...

  ClusterFerret68

  Discussions |

  Jun 8, 2023 12:34 PM

  3874 views | 8 replies