Listbox search operator for "unequal"

[pennetzdorfer]

Hey,

when I want to make a selection like "ALL minus XY" I usually pick "XY" from a listbox and "Select Excluded" from the context menu.

Example: Select all countries apart from Austria

1. Select Austria from Countries listbox
2. Right-click, Select Excluded

Result: In the "Current Selections" I see "NOT Austria".

Is there search expression for listboxes in order to get the same result directly?  I guess there should be a "unequal" operator ...

I already tried

• <> 'Austria'
• = NOT 'Austria'

Regards,

Florian

[#2]

Please see the attached the QV application

You can use any of the expressions

Regards

Mhatim

[MayilVahanan]

Hi

Try like this

Document properties-trigger-> select the Countries field name , add trigger "Onselect", SelectExcluded , Field -> Countries

SO whenever you select the field, its excluded that and show the remaining field..For example, when u select Austria, its select other than Austria in Countries list box.

Hope that helps

[#4]

Hi,

try this in the list boxe's general tab:

Field-> Expression -> Edit...

=if(Countries='Austria',null(),Countries)

Have fun

MC

[#5 · Accepted solution]

I got your question wrong.

You can use - before your selection to exclude that in the search

Thanks

Mhatim

[pennetzdorfer]

Thanx mhatim - that's exactly what I meant!

For alphanumeric it works perfectly, but what if I have numeric values in my listbox? Example: a listbox containing discounts in %   --> I want to select all sales positions that didn't have a 100% discount.

Self-evidently, the minus operator doesn't work in that case ...

Regards,

Florian

[#7]

Use < 100%

[pennetzdorfer]

Oh ... sure!

It has been a long day

Thanks!

[erichshiino]

If that was a different number, althought you can not use, for instance, <> 5 and -5 would not make sense, you could use >5<5 to ignore just the number 5 ( or even to create any other range)

Regards,

Erich