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

54666_en-US

liliconcom

How to get "AND" in filter in sql query builder with JMP14

Hi,

with the sql query builder, we can add several filters like the picture below. We have always "OR" with the filters. Could it be possible to have "AND" instead of "OR"?

sql pb filtre.png

Re: How to get "AND" in filter in sql query builder with JMP14

I've posted another question the same day about the sql.

M. Perkinson, have you the answer because I'm stuck!

Re: How to get "AND" in filter in sql query builder with JMP14

Thanks very much! It's OK!

Re: How to get "AND" in filter in sql query builder with JMP14

To get AND just add your additional variables to the filter by selecting them and clicking the "Filter" button.

QueryBuilder Filter.gif

You can use shift- or ctrl-click to select multiple columns and click the filter button once.

QueryBuilder Filter2.gif

Comments

There are no comments yet