Predefined number series (dropdown) with dynamic max value

[#1]

I have an input box which provided the user with a drop down with a number series, currently hard-coded 1-12 in the variable settings. I want to be able to change the max value based on another variable/field. 

- I am unable to enter an expression in the "To" field.

- I am also unable to set huge max ie: 1-1000 and then filter which values are visible based on another variable.

Any suggestions?

[#2]

Here is a simple test app which should be identical to yours.

[rwunderlich]

Jessica Ben You need to change your list separator to "," instead of ";".  swuehl is in Europe so his list separator is ;.

You can find out what the ListSep is on your machine by looking at Help, Document Support Info from the QV menu.

To clarify why swuehl's example worked when downloaded but not copied. The Document ListSep is set from the Sys (machine value). So the example document provided set the Document ListSep to ; (semicolon). But when the expression was copied to a new North America document, it expected the Sys default of , (comma)

-Rob

http://masterssummit.com

[#4]

WONDERFUL!!! That does it!

[#5]

Hey Rob,

Quick question though.

If Listsep = "," for both Sys and Doc, then how come when you use 1;2;3 it works fine? I am little confused. Whats the difference between this and the one in the expression. why use ; in one place and , in another.

Also can you change Listsep?

Thanks

AJ

[rwunderlich]

Ajay,

It's true that when you hard code the list, you use semicolon as the sep per the doc. When generating the list, you must use the sep that matches the Doc ListSep.

That difference has been a mystery to me for some time. My guess is a different parser is being used for the literal expression string vs the generated string. That's a fancy way of saying "I don't know".

This thread is where I first heard about the issue from Miguel Angel Baeyens

Input Box and Concat

I don't know of a way to neutralize the problem when coding the dynamic list. While you can get the Sys ListSep with the expression:

=getregistrystring('HKEY_CURRENT_USER\Control Panel\International','sList')

I don't know of any way to get the Doc ListSep. The good news is that once Doc ListSep is set, it doesn't change.

You can change ListSep via Window Control Panel, Regional Settings. But that may have some side effects.

-Rob

http://masterssummit.com

[#7]

Thanks for taking the time to explain Rob. Learnt something new today