topic Conditional selection in list box in QlikView

Conditional selection in list box

Thu, 06 May 2010 10:28:34 GMT

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!

Conditional selection in list box

Thu, 06 May 2010 10:35:42 GMT

Enter in the search string like the way shown below

a*

Conditional selection in list box

Thu, 06 May 2010 10:38:07 GMT

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

Conditional selection in list box

Thu, 06 May 2010 10:41:29 GMT

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?

Conditional selection in list box

Thu, 06 May 2010 10:45:25 GMT

ya! leroy!

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

Conditional selection in list box

Thu, 06 May 2010 11:11:31 GMT

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

Conditional selection in list box

Thu, 06 May 2010 11:12:46 GMT

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

Conditional selection in list box

Thu, 06 May 2010 11:21:51 GMT

hi,

pls see the attahed application

it should work

thanks

Conditional selection in list box

Thu, 06 May 2010 11:45:09 GMT

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

Conditional selection in list box

Thu, 06 May 2010 11:56:14 GMT

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.

Conditional selection in list box

Thu, 06 May 2010 12:02:57 GMT

Hi Rikab,

Since there is no names in the list box that starts eith A, how come you will see the names starting with A. So please do check the data that is there in the application and then reply.

Thanks

Conditional selection in list box

Thu, 06 May 2010 12:05:42 GMT


Thopz wrote:
Since there is no names in the list box that starts eith A, how come you will see the names starting with A. So please do check the data that is there in the application and then reply. <div></div>

You type N in the search option you will get to know whats wrong.

Conditional selection in list box

Thu, 06 May 2010 12:06:11 GMT

Hi Rikab,

If you enter a combination of words then it will work fine............

Thanks........

Conditional selection in list box

Thu, 06 May 2010 12:14:40 GMT

thanks a lot tauqueer.....

Conditional selection in list box

Thu, 06 May 2010 12:22:58 GMT

its working tanqueer!!!! thank u

Conditional selection in list box

Thu, 06 May 2010 12:26:53 GMT

thanks 4 all guys!

Conditional selection in list box

Thu, 06 May 2010 13:40:15 GMT

hi....

instead of giving starting letter in input box,could we achieve in listbox???

while clicking any letter(starting letter) in listbox should give the names starting with that letter...

how to do this?

thanks

bharathe

Conditional selection in list box

Thu, 06 May 2010 22:52:11 GMT

Replace *A* by A* in the search inputbox of the listbox to have as results all the names starting with A