Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
selvakumara
New Contributor III

Add Two fields values into Single Dropdown

Hi ,

Is it possible to use two fields values into a dropdown.

Eg:  I need to show two fields values in one drop down.

Need to display "ALL" and [ProgramNames] field values in the drop down

But here instead of List of programs displaying only [Program Name].

Thanks2018-02-15_20h09_39.png

5 Replies
zebhashmi
Valued Contributor

Re: Add Two fields values into Single Dropdown

=field1&' '&field2

jaumecf23
Contributor III

Re: Add Two fields values into Single Dropdown

Maybe you can create a new field that only will have values if the original value is ALL or and [ProgramNames] . You have to create this field in the script.

selvakumara
New Contributor III

Re: Add Two fields values into Single Dropdown

Ok, But how these values come to inside the dropdown

zebhashmi
Valued Contributor

Re: Add Two fields values into Single Dropdown

Are you using qlik sense? by drop-down, you mean filter panel?

selvakumara
New Contributor III

Re: Add Two fields values into Single Dropdown

Yes. I'm using Qlik sense. I'm using Variable extension. In that we have a drop down list.

In that drop down list I want to display the field values one by one

Eg: Inside the variable if i use [Program Name] means,

The drop down should display list of program name rather than label [Program Name]

In the below screen shot will help to understand more

Capture.PNG