Checkbox link to list box

[#1]

Hi, I am totally new to Qlikview.

How to create a checkbox and link to a list box with search button?

Example:

If I had 4 column, once I select a column, let say "Region", the region name will appear in list box (which is limited list only).

But when I select "AE_Name", the AE_Name will appear in list box (more than 50 name), and I can use the search box to find the name.

Please see the picture attached.

Any idea I should begin with? Thanks.

Benjamin See

[sujeetsingh]

List box have option of search so you can use it .

[shawn-qv]

I would suggest using QlikView's in-built functionality as much as possible, rather than re-creating them which would require a lot of time and effort, and possibly even hard to maintain.

With a ListBox object, a user can type part or whole words, and the list will start to filter itself for matches. Simply highlight the object and start typing. It is also common to display the "search" icon in the caption bar to emphasize this function.

If you're only wanting to show one listbox at any one time (i.e. Region, HOR, HOS, etc...), you can certainly create another list for that and enable the "Always one selected value" option.

S.

[Anonymous]

Please refer to below image.

Hope it helps you

[#5]

Thanks for the idea.

But I can't enable the "Always one selected value" function. Any idea?

Benjamin See

[shawn-qv]

You need to select one value from the listbox first, then you'll be able to enable that option in Properties.

[#7]

Hi Shawn,

Thanks. The Listbox only allowed me to add only 1 field. Please may you guide me how to add another field to the list box?

Regards

Benjamin See

[Anonymous]

In list box , we can only add one field,

For multiple fields there is Multibox in which you can add more than 1 field....

[sivarajs]

Go with Multi box if you want to add more than one field

[shawn-qv]

You can quite simply create an inline table. Example:

ListboxSelection:

load * inline [

  ListID, ListName

  1, Region

  2, HOR

  3, HOS

  4, AE Name

  5, Distributor

  6, Cluster

  7, Micro Market

];

This doesn't need to tie into your data model (unless you want it to). You can then use GetFieldSelections() to identify which ListName value is selected.

You will need to have 7 individual listboxes (one listbox for the fields Region, HOR, HOS, etc...).

On each listbox, apply a Conditional Show (e.g. = GetFieldSelections(ListName) = 'Region'). Alternatively, you can store it into a variable for easier maintenance (i.e. vListNameSelected =  GetFieldSelections(ListName) ).