Input Box Object - Dynamic Listed Values

[#1]

I'm sure everyone has done this, create a input box object and in the "Listed Values" expression add a distinct field in your data set.  It seems straight forward, I've read the documentation and old posts, but still can't get it to work.  See attached .qvw.  Any help would be appreciated.  Thanks!

[Sokkorn · Accepted solution]

Hi dcbonnet,

Let do this =Concat([Year],',') instead of =concat(chr(39)&[Year]&chr(39),';')

See the sample attached file.

Hope this help.

Regards,

Sokkorn

[#3]

Sokkorn - Thank you it works.  I was thinking of doing that but according to documentation a semicolon is suppose to be used to seperate values.  Anyway thank you very much for taking the time to respond to my post, hopefully this helps somebody else out in the future.

[rwunderlich]

This is an ongoing source of confusion.

http://community.qlik.com/message/143350#143350

The seperator is ";" for most european machines, ",' for US machines and I've seen "." as well. Search ListSep in the forums and you'll find lots of info on it. The key is that the Doc ListSep gets set from Windows settings when the document is created, and thereafter can't be changed for that document.

-Rob

[#5]

Thanks Rob.  This is great to know.