topic Input Box Value List in QlikView

Input Box Value List

Wed, 24 Dec 2014 18:19:53 GMT

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

Re: Input Box Value List

Anonymous — Wed, 24 Dec 2014 18:30:34 GMT

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

Re: Input Box Value List

Wed, 24 Dec 2014 18:39:07 GMT

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

Re: Input Box Value List

Wed, 24 Dec 2014 18:52:55 GMT

Hi ,

the below expression is working in my senario.

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

Thank you.