Display table column as dropdown to set variables

[#1]

Hi

I am new to Qlikview. I have this requirement to load data from a table and then use one of the columns as drop-down in qlikview to show clientName. Subsequently selected clientName in drop-down should be assigned to a variable name.

Names:

LOAD names as Names

FROM (biff, embedded labels, table is Sheet1$);

Now I am trying to create a Input Box in Qlikview and under Constraints tab, I ticked "Listed Values" and "Predefined Values in Drop-down". But not sure how to access Names as list values in expression.

Subsequently, I need to figure out that selected value in Input Box drop-down is assigned (set to) one of the variables.

Also, I am not sure if there is a more efficient way to achieve same.

Many Thanks

Rahul

[#2]

Following will do:

predefined values in drop down for variable from field selection