topic Re: Alphabetical Filter for a List Box in QlikView

Alphabetical Filter for a List Box

Anonymous — Tue, 24 Jun 2014 12:34:43 GMT

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.

Re: Alphabetical Filter for a List Box

Tue, 24 Jun 2014 12:40:11 GMT

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

regrads,

Re: Alphabetical Filter for a List Box

Anonymous — Tue, 24 Jun 2014 12:41:58 GMT

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

Re: Alphabetical Filter for a List Box

veidlburkhard — Tue, 24 Jun 2014 12:42:07 GMT

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:

Re: Alphabetical Filter for a List Box

tresB — Tue, 24 Jun 2014 12:44:14 GMT

Create a listbox with expression like:

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

Re: Alphabetical Filter for a List Box

martinpedersen — Tue, 24 Jun 2014 12:49:22 GMT

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?