topic Re: Filter possible list items in List Box in QlikView

Filter possible list items in List Box

Thu, 08 Nov 2012 09:39:49 GMT

Good morning. I'm new to Qlikview so apologies if this is a silly question however I cannot seem to find a solution and was hoping you could help.

I have a set of data available and would like to use this on a dashboard as a potential filter item for individual managers to select their teams and then their peer teams for comparison, however I only want the list box on the dashboard to contain a subset of the entire list. Is this possible?

So for example, if the data contains a filed entitled "Team" and in that team list there were listed 20 teams however for the list box potential selection I wanted to show only 5 of those teams, how can I do this?

I've tried playing with the list box to hide escluded items, but this then does not allow them to see the other 4 items for future selection when looking at peer comparison.

Any help greatly appreciated.

Thanks

Mark

Re: Filter possible list items in List Box

Siva_Sankar — Thu, 08 Nov 2012 09:51:05 GMT

Following link would help. http://community.qlik.com/message/163230#163230 Regards. Siva

Re: Filter possible list items in List Box

swuehl — Thu, 08 Nov 2012 10:21:22 GMT

If you want to filter the values in your list box, you can either create a new field in your team table with only the values you want to display, or create a field expression in your list box (select <Expression> from the field drop down list in properties) then enter something like

=if( match( Team, 'Team1', 'Team2', 'Team3', 'Team4', 'Team5'), Team)

Re: Filter possible list items in List Box

Thu, 03 Jan 2013 20:47:30 GMT

Hi swuehl,

You are absolutely right, that resolved my problem.

Re: Filter possible list items in List Box

Thu, 12 Feb 2015 12:57:15 GMT

Thanks!! Helped me!