Alphabetical Filter for a List Box

[Anonymous]

Hello my QV friends.  I have a listbox with a long list of names in it.  To aid the user of my app, I thought about creating a  separate filter to find the list of names that begin with C, for example.  Is it possible to create a separate filter for a listbox to narrow the list of options?  Thank you.

[#2]

you can use the search function of the list box typing *c*

regrads,

MT

[Anonymous]

Thank you for your reply.  I was wondering if there is a way to code this search?

[veidlburkhard]

Hi thnkgreen,

the list box already has a built-in filter. Type in C and it will show you all the fieldvalues with C. See picture below:

[tresB]

Create a listbox with expression like:

=If(WidlMatch(YourDimension, 'C*'), YourDimension)

[martinpedersen · Accepted solution]

Like a trigger or in the script?

If you are looking for a way to group your values into alphabetic lists or something like that, then you could do it in the load script:

DataTable:

Load

YourValue, Left(YourValue, 1) as YourValueGroup From data.qvd (qvd);

Then you could add a two list box with both YourValue and YourValueGroup - or you could set the Listbox with "YourValue" to show only when you have made a selection in "YourValueGroup".

If its something like this you are looking for i could make an example document?