Qlikview function in a list box(search)

[#1]

Hi,

Is it possible to show :the Country(Pays) contains "FR" and "AM" with a query (like ... and) in the research selection ?

Thanks,

[#2]

Hi,

If you click with the right mouse button and select "Advanced Search" you can select the way you need. You must also enable search. Look below:

[#3]

Thanks Rebeca.

[Anonymous]

Sounds like you want a wildcard search, which is the default type.

- If you click on the caption of the list box and type 'fr' it will find all those with 'fr' anywhere in the text ('*fr*').

- If you click on the caption of the list box, press the spacebar and then the backspace button, and then type 'fr' it will find all those starting with 'fr' ('fr*').

- If you click on the caption of the list box and type 'fr*am' it will find all those with 'fr' followed by 'am' anywhere in the text ('*fr*am*').

- If you click on the caption of the list box, press the spacebar and then the backspace button, and then type 'fr' *am it will find all those starting with 'fr' followed by 'am' ('fr*am*').

I don't know of a way of searching for 'fr' then 'am', or 'am' followed by 'am'. However, if you think they may be in the same word you can change the default type from widcard to fuzzy on the right hand-side of the general tab properties of the list box.

If you then click on the caption of the list box and type 'france' it will find all those with anything close to 'france', allowing for some typos.

Jonathan

[#5]

Hey! If my answer helped you, mark it correct, please!