topic Re: Checkbox link to list box in QlikView

Checkbox link to list box

Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Checkbox link to list box

sujeetsingh — Mon, 24 Feb 2014 04:27:11 GMT

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

Re: Checkbox link to list box

shawn-qv — Mon, 24 Feb 2014 04:30:28 GMT

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.

Re: Checkbox link to list box

Anonymous — Mon, 24 Feb 2014 04:36:46 GMT

Please refer to below image.

Hope it helps you

Re: Checkbox link to list box

Mon, 24 Feb 2014 04:55:24 GMT

Thanks for the idea.

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

Benjamin See

Re: Checkbox link to list box

shawn-qv — Mon, 24 Feb 2014 05:03:08 GMT

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

Re: Checkbox link to list box

Mon, 24 Feb 2014 06:05:24 GMT

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

Re: Checkbox link to list box

Anonymous — Mon, 24 Feb 2014 07:02:04 GMT

In list box , we can only add one field,

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

Re: Re: Checkbox link to list box

sivarajs — Mon, 24 Feb 2014 07:11:27 GMT

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

Re: Re: Checkbox link to list box

shawn-qv — Mon, 24 Feb 2014 08:09:48 GMT

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) ).

Re: Checkbox link to list box

jonathandienst — Mon, 24 Feb 2014 08:32:48 GMT

You can do this with 7 listboxes, but its not necessary. Assuming that the field for the checkboxes is called ListboxSelection (as in the previous post), use the following in the Listbox:

Select <Expression> for the listbox
Type =[$(=ListboxSelection)]

Now when you change the selected value from ListboxSelectedValue, the second listbox will show the values from the field selected.

HTH

Jonathan

Re: Checkbox link to list box

shawn-qv — Mon, 24 Feb 2014 10:05:41 GMT

Yes, this is true. If the field names are identical in spelling to the values under the field ListName, then you can quite simply create just one ListBox, and use the expression as suggested above. E.g. =[$(=ListName)]

Re: Checkbox link to list box

nagaiank — Mon, 24 Feb 2014 10:20:02 GMT

A sample application is attached.

Re: Checkbox link to list box

ashwanin — Mon, 24 Feb 2014 10:21:55 GMT

You can also use Search object, if you want to include the data of all 4 columns.

right click--> Search Object.

Re: Checkbox link to list box

Fri, 17 Oct 2014 04:02:49 GMT

hello Benjamin See,

I hope this answer might be help you. Please Right click on the listbox In Presentation Tab,choose LED check boxes in Selection Style Override. see image below :