Conditional filters with Query Builder (JMP table or SQL)Is this feature disabled or am I missing something?
Re: Conditional filters with Query Builder (JMP table or SQL)Working fine for me in 15.1 from JMP table Query Builder.
Will work up a quick example to share.
Re: Conditional filters with Query Builder (JMP table or SQL)Don,
Conditional filters work for me (both Query Builder's Run Query or re-run as a saved script). I run 15.0. The screenshots below show the setup of hierarchical filtering movie ratings within class.
Is this something you were looking for?
Re: Conditional filters with Query Builder (JMP table or SQL)Don,
Using filters causes JMP to crash for me. I reported it a while back, and I found out that it has been an issue in 15 for some, but not all.
Best,
Bill
Re: Conditional filters with Query Builder (JMP table or SQL)Thanks Guys. The conditional filter only works when applied to columns from the same table. It also honors the hierarchical organization of the filters, a filter is applied to filters (from the same table) below, but not above. You can have more than two conditional filters. You can also have multiple conditional filters with, for example, two filters from one table with a conditional relationship and two from a different table. They behave independent from one another, however. The behavior is the same for both JMP and SQL Query Builders.
Re: Conditional filters with Query Builder (JMP table or SQL)Bill, be interesting to know under what conditions the crash is occurring. Do you have a tracking #.
