Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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 .

5 Replies
advait_thakur
Creator III
Creator III

Hi,

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

Thanks

Advait

Join the official Qlik Enthusiast's page here
https://www.linkedin.com/groups/6513382/
jagannalla
Partner - Specialist III
Partner - Specialist III

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

hi

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

     Tthen write

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

and then check on predefined selected listed values,

er_mohit
Master II
Master II

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
Creator II
Creator II
Author

thanks for all replies,

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