Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Valued Contributor III

predefined values in drop down for variable from field selection

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

6 Replies
disqr_rm
Valued Contributor III

predefined values in drop down for variable from field selection

Try with comma instead of semi-comma:

=concat(FIELD,',')

Not applicable

predefined values in drop down for variable from field selection

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
Valued Contributor III

predefined values in drop down for variable from field selection

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

Not applicable

predefined values in drop down for variable from field selection

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
Contributor

predefined values in drop down for variable from field selection

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

bradshields
Contributor

predefined values in drop down for variable from field selection

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

Community Browser