predefined values in drop down for variable from field selection

[#1]

Hi,

I want to let the user pick the value for a variable from a range of selected values in a field list.

I tried in input box properties: predefined values only, predefined values only, listed values

and in listed values I entered =concat(FIELD,';').

Instead of getting the dropdown with field values as expected I got the concatenated Fieldvalues as one value. Any idea how to get a dynamic field selection based dropdown list in an input box?

Many thanks

[disqr_rm]

Try with comma instead of semi-comma:

=concat(FIELD,',')

[#3]

Rakesh,

thanks for your answer but this leads to the same result. If FIELD contains values A,B,C concat(FIELD,';') gives the value 'A;B;C' instead of the value list 'A'; 'B'; 'C' (the same with comma instead of semicolon).

Any other idea ?

[disqr_rm · Accepted solution]

May be I am mising something. See enclosed. Isn't this what you are looking for? Sorry if I misunderstood.

[#5]

Sorry Rakesh,

I tried this in an older QV document and it did not work - but now with your example it is fine (and exactly what I tried to do before...) and now after deactivating the dropdown list, apply and reactivation and applying it works in the old application, too. Anyway, why I have to use ',' in the concat and ';' as separator when I type in a list is not self-evident...

Again thanks a lot for your patience

[pgdavis2]

Thanks - I was trying to figure this out too. This works!

[bradshields]

If you are running this concat command on a large fact table it can be quite slow. Using distinct makes it nice a fast.

= concat(distinct field, ',')