Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor III
Contributor III

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

5 Replies
Highlighted
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.

Highlighted
Creator
Creator

Hi Jerry,

Is this for QlikView or Sense?

Highlighted
Contributor III
Contributor III

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

Highlighted
Contributor III
Contributor III

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

Highlighted
Contributor II
Contributor II

Is this possible in QlikView?