topic Re: Input Box Object - Dynamic Listed Values in QlikView

Input Box Object - Dynamic Listed Values

Mon, 30 Jul 2012 23:46:50 GMT

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!

Re: Input Box Object - Dynamic Listed Values

Sokkorn — Tue, 31 Jul 2012 01:36:11 GMT

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

Re: Input Box Object - Dynamic Listed Values

Tue, 31 Jul 2012 14:45:28 GMT

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.

Re: Input Box Object - Dynamic Listed Values

rwunderlich — Tue, 31 Jul 2012 15:08:22 GMT

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

Re: Input Box Object - Dynamic Listed Values

Tue, 31 Jul 2012 15:11:52 GMT

Thanks Rob. This is great to know.