Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Checkbox link to list box

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

14 Replies
Highlighted
Master III
Master III

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

Highlighted
Creator
Creator

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.

listbox.JPG

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.

listbox2.JPG

S.

Highlighted
Specialist II
Specialist II

Please refer to below image.

Hope it helps you

Check.png

Highlighted
Not applicable

Thanks for the idea.

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

Benjamin See

Highlighted
Creator
Creator

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

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

In list box , we can only add one field,

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Creator
Creator

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. vListNameSelectedGetFieldSelections(ListName) ).