topic Re: input box entering multiple values in QlikView

input box entering multiple values

QSense — Tue, 26 Mar 2013 08:05:46 GMT

hi,

I have a field includes number values,

I want to copy this values into input box but instead of entering many commas manually (850 values) in input box,

Can I add commas automatically in order to seperate values in input box.

Thanks .

Re: input box entering multiple values

advait_thakur — Tue, 26 Mar 2013 08:12:19 GMT

Hi,

Unfortunately this is not possible in input box. We can enter only single value in input box.

Thanks

Advait

Re: input box entering multiple values

jagannalla — Tue, 26 Mar 2013 08:33:24 GMT

Yes, you can do this.

Add a variable to input box and go to the constraints tab of input box. Select the variable and check the radio button of Predefined Values in Drop-down of Value List and also check Listed Values box of Predefined Values. Now you can see expression box bottom of this check box. Paste the below code there.

=Concat(DISTINCT FIELDNAME,',')

Hope it helps you

Cheers!!

Jagan

Re: input box entering multiple values

Tue, 26 Mar 2013 08:44:31 GMT

INPUTBOX-->PROPERTIES--> CONSTRAINTS-->LISTED VALUES

Tthen write

= concat(distinct(fieldname),',')

and then check on predefined selected listed values,

Re: input box entering multiple values

er_mohit — Tue, 26 Mar 2013 08:45:37 GMT

in constraints tab of input box write

=concat(distinct(fieldname),',')

check on list and write above code

tick on the radio button of predefined value in drop down

Re: input box entering multiple values

QSense — Tue, 26 Mar 2013 11:44:28 GMT

thanks for all replies,

er.mohit your reply is working for my case but for 850 values is problem for apllication