topic Re: List box filter settings in QlikView

List box filter settings

Mon, 16 Jul 2012 01:39:38 GMT

I have developed a search box for a FAQ for a project, but am having some issues with what happens when a button is selected to filter certain items. The two main issues I am experiencing are below:

1. When a button is selected for data and it is not at the top of the list box, it will be highlighted but will not automatically move to the top of the list box. Is there a setting where when a certain categories button is selected all of it's specific options will be moved to the top of the list box?

2. When a certain option in the list box is selected, for some reason this option and the one below it are both brought to the top of the listbox. Is there a setting to prevent this and only have the selected option move to the top?

I've attached an example Qlikview file and associated excel spreadsheet as a resource if anyone has a way to resolve these issues.

Re: List box filter settings

nagaiank — Mon, 16 Jul 2012 02:34:41 GMT

The following sort settings seem to give the result you want.

Re: List box filter settings

Mon, 16 Jul 2012 14:25:30 GMT

Thanks for the help. This has resolved the previous issue of two answers moving to the top of the list, but the issue about the questions associated with a category moving to the top of the list box when that category's button is selected (issue 1) is still arising. Any idea how to resolve that?

Re: List box filter settings

MayilVahanan — Mon, 16 Jul 2012 14:39:29 GMT

Hi,

Check the attached file..

Hope it helps

Re: List box filter settings

nagaiank — Mon, 16 Jul 2012 14:42:29 GMT

Probably I do not understand the problem.

When you click on the 'Administrative' button, all permissible Answer values are white and move to the top of listbox. When you click on the 'Data' button, all permissible Answer values are white and move to the top.

If you select any Answer item, the selected item is green and moved to the top.

I may be able to help if the issue is stated more clearly.

Re: List box filter settings

Mon, 16 Jul 2012 14:46:09 GMT

Yeah for some reason my copy is not performing the same maneuvers. I will review my production copy of my actual product and let you know if any more issues arise.