Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

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

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

View solution in original post

9 Replies
sunny_talwar

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

jblomqvist
Specialist
Specialist
Author

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

kkkumar82
Specialist III
Specialist III

can you share your app once

kkkumar82
Specialist III
Specialist III

Its seems case sensitive , try with B

sunny_talwar

May be try changing your default search mode to Wildcard search

Capture.PNG

Anil_Babu_Samineni

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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
awhitfield
Partner - Champion
Partner - Champion

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

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

jblomqvist
Specialist
Specialist
Author

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