Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
stevelord
Specialist
Specialist

Quick question about consolidating ANDs and ORs in expressions

Is there a way to write lines like this without all the expressions connected by ANDs?

fieldname>0 AND fieldname<100 AND fieldname<>otherfieldname

Something like Where(fieldname,>0,<100,<>otherfieldname)?

I know this expression is wrong, but looking for a function/expression syntax that is more compact than piling up ANDs and ORs because some of the fieldnames are long and/or paranthesis are running amok in my script.

0 Replies