This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
- JMP User Community
- :
- Discussions
- :
- Checking data with test limits
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Checking data with test limits
Jun 21, 2010 04:02 PM
(3537 views)
Hi Guys,
Is there any way I can check each cell value in a column against the column's test limits and decide if the test has passed or failed? For example if a column has 10 rows of data and if 5 out of the 10 rows fail the test limits for that column, I would like to see a message in a box that says column 'X' failed.
Thanks.
Is there any way I can check each cell value in a column against the column's test limits and decide if the test has passed or failed? For example if a column has 10 rows of data and if 5 out of the 10 rows fail the test limits for that column, I would like to see a message in a box that says column 'X' failed.
Thanks.
13 REPLIES 13
Level VII
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Checking data with test limits
Removed
Message was edited by: mpb
Message was edited by: mpb
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Checking data with test limits
Ok I am trying something like this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Checking data with test limits
You use the Column function to reference a column
e.g. colRef = Column("test")
To reference a cell within the column you specify the row number
e.g. cellValue = colRef[5]
If you use the For Each construction then [] will reference the current row for each iteration of the loop. The following code will work for you:
e.g. colRef = Column("test")
To reference a cell within the column you specify the row number
e.g. cellValue = colRef[5]
If you use the For Each construction then [] will reference the current row for each iteration of the loop. The following code will work for you:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: Checking data with test limits
Why not use the formula editor as explained to you by Lou? Then you wont have to worry about writing code?
- « Previous
-
- 1
- 2
- Next »
- © 2024 JMP Statistical Discovery LLC. All Rights Reserved.
- Terms of Use
- Privacy Statement
- About JMP
- JMP Software
- JMP User Community
- Contact