Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
Not applicable

Input Box Value List

Hi,

Can any one tried showing a drop down list of values in Input Box?

The values should come from one field like (Country, Name etc..)

eg: I want to show all countries in my 'country' field in a input box dropdown list( to ensure no typo errors )

Is it possible?

In Input Box properties, Constraints Tab->Listed Values->

=Concat(Distinct Country,';')

I used above expression and it showing in single row, but need it in multiple rows...

Help me..

3 Replies
Highlighted
Creator II
Creator II

HI

Try this

=ValueList($(=concat({1} distinct chr(39) & Col1 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col2 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col3 & Chr(39),',')))


where col1,col2,col3 are column names


Regards

Harsha


Highlighted
Not applicable

It's not working Harha, but thank you for responding..

Highlighted
Not applicable

Hi ,

the below expression is working in my senario.

=Concat({1} distinct Country,',')

Thank you.