topic Get Value for input box from drop down list? in QlikView

Get Value for input box from drop down list?

picturebox — Thu, 02 Sep 2010 17:14:14 GMT

Hi,

I'd like to offer the user a range of values from an existing field to "pick list" from for the input box. I can't seem to be able to make it work... what is the syntax I require? The field name is CWNumber and has 106 values 201033, 201032, 201031, ...., 200815. This example is based on numerical calendar weeks...

Thanks,

Petra

Get Value for input box from drop down list?

johnw — Thu, 02 Sep 2010 22:57:47 GMT

Input box properties, Constraints, Value List, select "Predefined Values in Drop-Down". Under Predefined Values, checkmark Number Series, from 201033 to 200815, step -1.

Get Value for input box from drop down list?

rwunderlich — Fri, 03 Sep 2010 05:35:56 GMT

On InputBox properties, Constaints, PreDefined Values, check "Listed Values" and for the expression use:

=concat(TOTAL DISTINCT CWNumber',')

-Rob

Get Value for input box from drop down list?

picturebox — Fri, 03 Sep 2010 08:24:39 GMT

Thanks John,

this is not a series, so cannot use -1 backstep.

Petra

Get Value for input box from drop down list?

picturebox — Fri, 03 Sep 2010 08:27:08 GMT

Thanks Rob,

this works perfectly once I got the proper syntax for my region, i.e. semi colon instead of comma. But what happens if I move the app onto a pc with comma separator? (local set Germany == 😉

Regards,

Petra

Get Value for input box from drop down list?

tanelry — Fri, 03 Sep 2010 14:11:57 GMT

Based on my test the function accepts document-based ListSep, not system-based one. So no worries.

Get Value for input box from drop down list?

picturebox — Fri, 03 Sep 2010 14:15:25 GMT

thanks!