Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be I am mising something. See enclosed. Isn't this what you are looking for? Sorry if I misunderstood.
Try with comma instead of semi-comma:
=concat(FIELD,',')
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 ?
May be I am mising something. See enclosed. Isn't this what you are looking for? Sorry if I misunderstood.
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
Thanks - I was trying to figure this out too. This works!
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, ',')