topic Exclude selectable values from fields in listbox in QlikView

Exclude selectable values from fields in listbox

Meg00 — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I'm trying to figure out how to exclude certain values to be selectable in a field.

There's a very long list of values and I only want the selectable values to equal 'W00*' and 'W1*'.

Would be awesome if anyone could help:)

Re: Exclude selectable values from fields in listbox

Miguel_Angel_Baeyens — Fri, 23 Aug 2019 07:46:21 GMT

Create a new field in the script that stores only those values:

If(Left(Field, 3) = 'W00' OR Left(Field, 2) = 'W1', Field, Null()) AS New_Field

Check the parentheses, though.

Re: Exclude selectable values from fields in listbox

marcus_sommer — Fri, 23 Aug 2019 07:49:15 GMT

You could use a simple if-condition within a listbox-expression for it. Another and maybe better way would be to categorize these field within the script to create a main- and maybe even n sub-groups and using them as an additionally listbox to restrict the data.

- Marcus

Re: Exclude selectable values from fields in listbox

Meg00 — Fri, 23 Aug 2019 08:01:09 GMT

Thanks, I tried IF with Match but that didn't work, Left worked much better!

Re: Exclude selectable values from fields in listbox

Miguel_Angel_Baeyens — Fri, 23 Aug 2019 09:47:21 GMT

Just for the sake of the example, the following will work with WildMatch().

If(WildMatch(Field, 'W00*', 'W1*') > 0, Field, Null()) AS New_Field

Match() does not allow wildcards such as "*" or "?", WildMatch() does.