Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QSense
Contributor II

input box entering multiple values

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 .

Tags (2)
5 Replies
advait_thakur
Contributor III

Re: input box entering multiple values

Hi,

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

Thanks

Advait

jagannalla
Valued Contributor III

Re: input box entering multiple values

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

Not applicable

Re: input box entering multiple values

hi

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

     Tthen write

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

and then check on predefined selected listed values,

er_mohit
Honored Contributor II

Re: input box entering multiple values

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

QSense
Contributor II

Re: input box entering multiple values

thanks for all replies,

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

Community Browser