topic Listbox search operator for "unequal" in QlikView

Listbox search operator for "unequal"

pennetzdorfer — Tue, 16 Oct 2012 14:26:45 GMT

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

Select Austria from Countries listbox
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

Re: Listbox search operator for "unequal"

Tue, 16 Oct 2012 14:38:09 GMT

Please see the attached the QV application

You can use any of the expressions

Regards

Mhatim

Re: Listbox search operator for "unequal"

MayilVahanan — Tue, 16 Oct 2012 14:38:58 GMT

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

Re: Listbox search operator for "unequal"

Tue, 16 Oct 2012 14:42:20 GMT

Hi,

try this in the list boxe's general tab:

Field-> Expression -> Edit...

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

Have fun

Re: Listbox search operator for "unequal"

Tue, 16 Oct 2012 14:43:31 GMT

I got your question wrong.

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

Thanks

Mhatim

Re: Listbox search operator for "unequal"

pennetzdorfer — Tue, 16 Oct 2012 15:20:03 GMT

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

Re: Listbox search operator for "unequal"

Tue, 16 Oct 2012 15:25:04 GMT

Use < 100%

Re: Listbox search operator for "unequal"

pennetzdorfer — Tue, 16 Oct 2012 15:34:04 GMT

Oh ... sure!

It has been a long day

Thanks!

Re: Listbox search operator for "unequal"

erichshiino — Tue, 16 Oct 2012 17:12:52 GMT

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