Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pennetzdorfer
Contributor III

Listbox search operator for "unequal"

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

1 Solution

Accepted Solutions
Not applicable

Re: Listbox search operator for "unequal"

I got your question wrong.

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

Thanks

Mhatim

8 Replies
Not applicable

Re: Listbox search operator for "unequal"

Please see the attached the QV application

You can use any of the expressions

Regards

Mhatim

Re: Listbox search operator for "unequal"

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

Not applicable

Re: Listbox search operator for "unequal"

Hi,

try this in the list boxe's general tab:

Field-> Expression -> Edit...

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

Have fun

MC



Not applicable

Re: Listbox search operator for "unequal"

I got your question wrong.

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

Thanks

Mhatim

pennetzdorfer
Contributor III

Re: Listbox search operator for "unequal"

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

Not applicable

Re: Listbox search operator for "unequal"

Use < 100%

pennetzdorfer
Contributor III

Re: Listbox search operator for "unequal"

Oh ... sure!

It has been a long day

Thanks!

erich_shiino
Honored Contributor

Re: Listbox search operator for "unequal"

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

Community Browser