topic dynamic input box in QlikView

dynamic input box

Tue, 28 Sep 2010 14:44:07 GMT

i would like to display the distinct values of a specific field in an input box.

how do i declare the variable?

Thanks,

Lambert.

dynamic input box

Tue, 28 Sep 2010 14:50:07 GMT

Do you want all values, selected values, possible values?

For all set a variable to:

=Concat({1} FIELD)

For selected:

=GetFieldSelections(FIELD)

Possible should just be:

=Concat(FIELD)

dynamic input box

Tue, 28 Sep 2010 14:59:25 GMT

i would like all distinct values in a dropdown list input box.

dynamic input box

Tue, 28 Sep 2010 15:13:16 GMT

Sorry, I saw variables and kind of missed the input box part. It doesn't seem like a variable works on a pre-defined list in an input box. The format is 'Val';'Val2';Val3'.

To get that in a variable it would be:

=Chr(39) & Concat({1} distinct FIELD, Chr(39) & ';' & Chr(39)) & Chr(39)

Unfortunately when that is used as the PreDefined list in an input box, it doesn't seem to work. Even though manually entering the same result would. I tried a few different things, like directly entering the expression and using a variable as =vVar, $(=vVar), $(vVar), etc. I don't use Input Boxes very often, so I'm not sure if that is possible. If it is, the above expression should work to get the values set up correctly.

EDIT: Numbers seem to work just fine, but don't require the quotes. For a numeric field:

Concat({1} distinct FIELD, ',')

That should show all values for the field and work as the Pre Defined list.

dynamic input box

Tue, 28 Sep 2010 15:22:39 GMT

Thanks for the reply, i will see what I can figure out.

dynamic input box

Tue, 28 Sep 2010 15:26:19 GMT

yeah, that worked, thanks a million!

dynamic input box

Tue, 29 Nov 2011 13:29:05 GMT

Thanks,

this works for me as well.