topic Re: searching multiple values in the ui in QlikView

searching multiple values in the ui

olivierrobin — Sat, 16 Nov 2024 04:59:39 GMT

hello

my problem is to search multiple values in the selected values of a field to activate conditional display

I can use instr() with getfieldselections() but it works with only one value. I have to find multiple values stored in a variable each value separated by a delimiter.

and another problem is that these values can have spaces and look similar.

e.g : the field may contain the values 'Mandatory' 'Not Mandatory'

any idea ?

Re: searching multiple values in the ui

henrikalmen — Tue, 11 Dec 2018 15:20:26 GMT

Could match() be a relevant function for your case?

Re: searching multiple values in the ui

olivierrobin — Tue, 11 Dec 2018 15:25:04 GMT

I don't think so ..

the values selected must have all the values of the variable.

for example , if ValueList=Value1,Value2 i have to check that those 2 values are contained in the selected values of the field

with match(), i will know that 0 or 1 of the values match, but not if all match

Re: searching multiple values in the ui

henrikalmen — Tue, 11 Dec 2018 15:40:44 GMT

I'm not sure I fully understand what it is you want to do. You have a variable with delimiter separated strings. You have a field with selections. How do these correspond and what is it that should be conditional? Perhaps you could give a practical example?

Re: searching multiple values in the ui

marcus_sommer — Tue, 11 Dec 2018 16:39:36 GMT

Maybe with something like this:

count({< Field *= {'$(var)'}>} distinct Field) = substringcount('$(var)', ',') + 1

with the requirement that '$(var)' contained a valid list of field-values including the needed quotes which might be created with: replace('$(varTemp)', ',', chr(39) & ',' & chr(39)).

- Marcus