Dropdown select commands

Fri, 14 Jun 2013 20:15:58 GMT

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

Re: Dropdown select commands

Gysbert_Wassenaar — Sat, 15 Jun 2013 08:36:41 GMT

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

topic Dropdown select commands in QlikView

Dropdown select commands

Re: Dropdown select commands