topic Searching for multiple values in a listbox where field is based on expression in QlikView

Searching for multiple values in a listbox where field is based on expression

Anonymous — Wed, 18 Jul 2018 12:06:27 GMT

I have a listbox where the field is based on a expression (defined by a variable).

I am unable to search for multiple values. I have tried the following (106, 107 are two numbers that show up in multiple values):

106|107
(106|107)
*106*|*107*
(*106*)|(*107*)
(*106*|*107*)
(106|107)

However when I make a brand new listbox with a fixed field, (*106*|*107*) seems to work fine. How do I make a listbox with a field based on expression allow for multiple search values?

Re: Searching for multiple values in a listbox where field is based on expression

ogautier62 — Wed, 18 Jul 2018 15:59:18 GMT

Hi,

that works in a sheet with check option search,

* and | ok

(you can hide dimension and it acts as a list box selection)

regards

Re: Searching for multiple values in a listbox where field is based on expression

sunny_talwar — Wed, 18 Jul 2018 16:05:06 GMT

What kind of expression are you using for the list box? Can this be moved to script because it might be straight forward to search like this for a expression based list box

Re: Searching for multiple values in a listbox where field is based on expression

Anonymous — Wed, 18 Jul 2018 17:20:54 GMT

Hi Olivier, not sure what you mean. Where is the check option search?

Re: Searching for multiple values in a listbox where field is based on expression

Anonymous — Wed, 18 Jul 2018 17:22:40 GMT

Hi Sunny,

The expression is literally just a variable

=$(vField)

The reason it is a variable is that I want the user to be able to choose what Field the listbox is showing. I just can't search for multiple values this way.

Re: Searching for multiple values in a listbox where field is based on expression

sunny_talwar — Thu, 19 Jul 2018 01:14:32 GMT

Will give it a try tomorrow to see if it can work...

Re: Searching for multiple values in a listbox where field is based on expression

ogautier62 — Thu, 19 Jul 2018 07:26:07 GMT

Hi,

maybe I replied too faster,it works too in a listbox :

in a generic character research :

use () in order to use |

so for you (106)|(107)

or this :

but I don't how combine * with |

Re: Searching for multiple values in a listbox where field is based on expression

ogautier62 — Thu, 19 Jul 2018 07:27:27 GMT

here :

but in fact it acts as a listbox selection with generaic character research

Re: Searching for multiple values in a listbox where field is based on expression

sunny_talwar — Thu, 19 Jul 2018 11:23:08 GMT

I am not sure what you are doing differently, but (107|108) worked for me where my list box expression is this

=$(=Dim)

And Dim is a field I used to determine which dimension I want to use in the list box object. Script is this

Table:

LOAD * INLINE [

Dim1, Dim2

107, 106

108, 107

109, 108

];

Dim:

LOAD * INLINE [

Dim

Dim1

Dim2

];