topic predefined values in drop down for variable from field selection in QlikView

predefined values in drop down for variable from field selection

Thu, 28 Jan 2010 18:04:03 GMT

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

predefined values in drop down for variable from field selection

disqr_rm — Thu, 28 Jan 2010 18:25:28 GMT

Try with comma instead of semi-comma:

=concat(FIELD,',')

predefined values in drop down for variable from field selection

Fri, 29 Jan 2010 17:05:28 GMT

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 ?

predefined values in drop down for variable from field selection

disqr_rm — Fri, 29 Jan 2010 17:38:26 GMT

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

predefined values in drop down for variable from field selection

Wed, 03 Feb 2010 14:11:35 GMT

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

predefined values in drop down for variable from field selection

pgdavis2 — Fri, 19 Mar 2010 14:17:00 GMT

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

predefined values in drop down for variable from field selection

bradshields — Fri, 03 Sep 2010 06:49:53 GMT

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