topic Re: How-To: Filter a List Box in QlikView

How-To: Filter a List Box

Thu, 23 May 2013 13:56:48 GMT

Hi,

I'm trying to filter a list box and I dont know how to. I have a database with a large number of records. I also have a report which is a subset of the records. I have a list box which displays all of the NAMES from the large number of records. I would like to filter the list box to only show NAMES that are in the report.

Can anyone help me.

Thanks,

Eamonn.

Re: How-To: Filter a List Box

Thu, 23 May 2013 14:11:23 GMT

Hi,

You can use an expresion into list box to show the record subset.

I hope help you.

Re: How-To: Filter a List Box

Mon, 27 May 2013 14:27:32 GMT

Hi Gregorio Zerpa,

Thanks for your reply.

I have been trying to use the expression option but no luck so far. I'm attaching a sample application which will show how I have tried to implement this. It will illustrate what I have tried and maybe help you show me how I should correctly get the filter I'm looking for.

I have inserted text on the app which should explain everything.

If you could have a look that would be great.

Thanks,

Eamonn.

Re: How-To: Filter a List Box

Mon, 27 May 2013 14:29:50 GMT

Hi Gregorio Zerpa,

Thanks for your reply.

I have inserted text on the app which should explain everything.

If you could have a look that would be great.

Thanks,

Eamonn.

Re: How-To: Filter a List Box

Mon, 27 May 2013 15:59:55 GMT

Hi,

Check listbox expresion.