How do you create a dropdown list from a field

[jerry_ile]

I would like to create a drop down list from a field and place the result in a variable

The field contains a list of Hosts.

Is this possible and if so please tell me how?

[dplr-rn]

You will need extensions. There are a few in Qlik Branch but not many are certified i.e.may cause issues when upgrading versions.

[snehamahaveer]

Hi Jerry,

Is this for QlikView or Sense?

[jerry_ile]

Hi Sneha,

This is for QlikSense

I have the Variable extension installed, it has dropdown in the options but I didn't get it working and found no info on how to use that aspect

[jerry_ile · Accepted solution]

Not to worried, figured it out.

I set up a Variable in Qlik called vDropdown

Then used the Variable extension. -

set Variable name as: vDropdown

selected Show as: Drop Down

Under values:

Set values as: Dynamic

and put the formula as

=concat(distinct FieldName, '|')   

with Fieldname being the list of values you wanted

[jessbanaga]

Is this possible in QlikView?

[NikosSpanos]

@jerry_ile  Your approach works fine. I wanted to ask if it's possible to have multi-selection instead of only single-selection in the drop down list. Is this feasible?