Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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?

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
Partner

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

View solution in original post

jblomqvist
Specialist
Specialist
Author

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