Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted
Specialist
Specialist

=field1&' '&field2

Highlighted
Creator III
Creator III

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.

Highlighted
Contributor III
Contributor III

Ok, But how these values come to inside the dropdown

Highlighted
Specialist
Specialist

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

Highlighted
Contributor III
Contributor III

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