topic Re: Qlikview function in a list box(search) in QlikView

Qlikview function in a list box(search)

Fri, 14 Dec 2012 16:00:06 GMT

Hi,

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

Thanks,

Re: Qlikview function in a list box(search)

Fri, 14 Dec 2012 16:55:36 GMT

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:

Re: Qlikview function in a list box(search)

Sat, 15 Dec 2012 20:56:41 GMT

Thanks Rebeca.

Re: Qlikview function in a list box(search)

Anonymous — Sun, 16 Dec 2012 09:43:48 GMT

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

Re: Qlikview function in a list box(search)

Tue, 18 Dec 2012 15:33:25 GMT

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