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: 
Not applicable

Dropdown select commands

Does anyone have any documentation on what commands are available in dropdown selects?

For example, I can type >40 <70 to get values greater than 40 AND less than 70.

I can type <40 >=70 to get less than 40 OR greater than or equal to 70.

I can type *qlik* to get anything with qlik in it, or qlik* for anything that begins with qlik.

I'd like to know how to do (not equal) <>50 AND <>70

and how to do <>*qlik* <>*other*, or NOT *qlik*, other*

Things of that nature.

Plus any other useful commands I may not know of.  Would be very useful

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I haven't found any documentation yet other than the help file.

to exclude 50 and 70 you can enter -50 -70. If you wanted to exclued a negative value you could use -"-40". As far as I know there's no way to enter a search string for <> *qlik*. For <> other* you can enter -other. For <> *qlik* you'll have to open the advanced search dialog (ctrl+shift+f) and enter an expression like =count({1-<MyField={'*qlik*'}>}1)>0


talk is cheap, supply exceeds demand