topic Re: Input Box - Using a loaded field for values in QlikView

Input Box - Using a loaded field for values

Mon, 05 Dec 2011 13:04:26 GMT

Hi All,

I want to create a input box that has a predefined drop-down list of values from a field... So that field has a distinct list...i want that list to appear in an input box for a user to select from

In the 'constraints' tab for an input box, I would like to enter "=FieldName1" in the predefined listed values section. Is it possible at all to do this

Thanks,
Byron

Re: Input Box - Using a loaded field for values

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 13:21:43 GMT

Hi Byron,

You're almost there. Go to the inputbox properties, Constraints, Listed Values, but set instead:

=Concat(DISTINCT Field, ',')

That will return a comma separated list of all distinct values for field "Field". Note that the comma may not be your list separator, to know which one will work if that doesn't, use Ctrl + Shift + Q and search for "ListSep", and you will see something like this in the dialog that shows up:

ListSep                            Doc=";"(3B)       Sys=";"(3B)

The "Doc" is the one that matters, so in my case, the separator in that Concat() function should be ";" instead of the comma. In this regard, check (and vote if you feel like) this idea so you as developer can choose the list separator instead of using the regional settings.

Anyway, once you get this working, make sure you check "Predefined Values in Drop Down" in the "Value List" section of the Constraints tab in the inputbox properties.

Hope that helps.

Miguel

Re: Input Box - Using a loaded field for values

Mon, 05 Dec 2011 13:39:03 GMT

Thanks Miguel...was actually just about to close this post cause I found a discussion you replied to with that function...worked like a charm... Thanks a lot mate for the detailed reply and answer. Full points