Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jblomqvist
Not applicable

Search in a Listbox does not work if the Lisbox values are from an expression?

Hi all,

When I have a Listbox based on an expression, I cannot search in the values of the listbox using the listbox's search functionality.

For example try this in a test application:

Script:

LOAD * INLINE [

    Key

    1

];

LOAD * INLINE [

    Country

    UK

    USA

    Belgium

];

//End of script

Listbox 1: Country field

Listbox 2: =If(Key=1, Country)

Listbox 2 values are not searchable compared to Listbox1.

Does anyone know a way around this for Listbox2?

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

The difference here is that we are doing WildCard search whereas OP isn't. I think OP needs to change to wildcard search

9 Replies
sunny_talwar
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

Seems to be working for me. What are you searching for?

jblomqvist
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

If I click on the magnifying glass for Listbox2 and type Bel it gives me blanks:

kkkumar82
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

can you share your app once

kkkumar82
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

Its seems case sensitive , try with B

sunny_talwar
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

May be try changing your default search mode to Wildcard search

Capture.PNG

loveisfail
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

Sunny, Did you got what he is referring to? Can you please elaborate for me.. So that, I can try. You mention something else *bel* after written that what he is expecting from our end? Bel is ok --> Where do you taken this Bel word?

Life is so rich, and we need to respect to the life !!!
awhitfield
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

Hi John,

works for me!

Key:
LOAD * INLINE [
  Key
1
  ]
;
 
Country:
LOAD * INLINE [
Country
UK
USA
Belgium

]
;

Make sure your dimension names match chase in the expression.

Andy

sunny_talwar
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

The difference here is that we are doing WildCard search whereas OP isn't. I think OP needs to change to wildcard search

jblomqvist
Not applicable

Re: Search in a Listbox does not work if the Lisbox values are from an expression?

Yes you guys are right, my default is not set to a wildcard search.