Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Conditional selection in list box

Hi all,

I have a list box of names.

when i entered a starting letter (ie A-Z) in Inputbox , the Names begining with that starting letter should be displayed in list box...

finally the output should be like this

Name Input box

Alex starting letter A

Alexander

How to do this? plz help me

thanks in advance!

1 Solution

Accepted Solutions
Not applicable

Conditional selection in list box

hi,

first create a variable (say y) in settings->variable overview

now go to documentproperties->triggers->variable triggers

in variable triggers select this variable x and give OnInput add action.give the action as "select in field". the field as Name in your case

and search string as =y&'*'

this should work

thanks



17 Replies
Not applicable

Conditional selection in list box

Enter in the search string like the way shown below

a*


Not applicable

Conditional selection in list box

Why don't you use the search tool included in your listbox header ?

Not applicable

Conditional selection in list box

Rikab Kothari

I know that option rikab! but i have to show the names only stating with the particular letter in the input box......

with the help of macros... whether we can do that?

Not applicable

Conditional selection in list box

ya! leroy!

i want to display the names in list box according to the letter in the input box without using the search!

Not applicable

Conditional selection in list box

hi,

first create a variable (say x) in settings->variable overview

now go to documentproperties->triggers->variable triggers

in variable triggers select this variable x and give OnInput add action.give the action as "select in field". the field as Name in your case

and search string as =y&'*'

this should work

thanks

Not applicable

Conditional selection in list box

hi,

first create a variable (say y) in settings->variable overview

now go to documentproperties->triggers->variable triggers

in variable triggers select this variable x and give OnInput add action.give the action as "select in field". the field as Name in your case

and search string as =y&'*'

this should work

thanks



Not applicable

Conditional selection in list box

hi,

pls see the attahed application

it should work

thanks

Not applicable

Conditional selection in list box

Hi Bharathi,

i have attached an application regarding your query. please check if it is fine with you. In QV 9.00 there is a new option called Search object. In order to use it you just need to add the corresponding field name into the search object and you will get the desired result.

Best Regards

Joseph

Not applicable

Conditional selection in list box

No it is not working as per his requirement. When you type A in the input box it should show those names which starts with A but in yours it shows all the names where A is available. It is not considering the position.