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; } } }

Conditional filters with Query Builder (JMP table or SQL)

DonMcCormack

Is this feature disabled or am I missing something?

Accepted answers

DonMcCormack

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.

All comments

Jordan_Hiller

Working fine for me in 15.1 from JMP table Query Builder.

Will work up a quick example to share.

jiancao

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?

Bill_Worley

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

DonMcCormack

Bill, be interesting to know under what conditions the crash is occurring. Do you have a tracking #.