Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jerry_ile
Contributor III
Contributor III

How do you create a dropdown list from a field

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?

1 Solution

Accepted Solutions
jerry_ile
Contributor III
Contributor III
Author

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

View solution in original post

6 Replies
dilipranjith
Partner
Partner

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
Creator
Creator

Hi Jerry,

Is this for QlikView or Sense?

jerry_ile
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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

View solution in original post

jessbanaga
Contributor II
Contributor II

Is this possible in QlikView?

NikosSpanos
Contributor III
Contributor III

@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?