Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

predefined values in drop down for variable from field selection

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

1 Solution

Accepted Solutions
disqr_rm
Partner - Specialist III
Partner - Specialist III

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

View solution in original post

6 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

Try with comma instead of semi-comma:

=concat(FIELD,',')

Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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

Not applicable
Author

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
Partner - Creator
Partner - Creator

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

bradshields
Partner - Creator
Partner - Creator

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, ',')