Hi, I am totally new to Qlikview.
How to create a checkbox and link to a list box with search button?
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.
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.
You can quite simply create an inline table. Example:
load * inline [
4, AE Name
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) ).