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

[jblomqvist]

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?

[sunny_talwar]

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

[jblomqvist]

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

[kkkumar82]

can you share your app once

[kkkumar82]

Its seems case sensitive , try with B

[sunny_talwar]

May be try changing your default search mode to Wildcard search

[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?

[awhitfield]

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 · Accepted solution]

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

[jblomqvist]

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