How to define a predefined list value

[#1]

Hi,
my name is Stefania and I'm new on Qlik develop.
I'm trying to define a predefined list of value using a sql statement.
After that, I would like to use this predefined list of value as input of my input box.
This is what I've wrtiten

Year: SQL SELECT ID FROM DATA.dbo.DIM_YEAR;
LET Input_yesr = Input ('Insert Year', 'Inpubox') ;

Can someone help me?
Thank's
Ciao Stefania

[IAMDV]

Please can you post an example?

[#3]

I'll try to explain:

when a user try to refresh a report, it should appear a messagebox, wich asks to insert an year; in the message bx I'd like to insert a predefined list value (wich I find out by a query).

Someting like a excel combobox.

can you help me?

thank's

[boorgura]

You can try to use an input box on the UI and capture the input into a variable.

In the input box, you can have a predefined set of values, which can be restricted.

[#5]

this is what I've done

but I refresh report, thi is what I obtain

I'd like to obtain something like combo box, where I can choose the right value.

On the script side I've written

LET Anno_estrazione = Input('Inserisci Anno di analisi', 'Anno di Analisi:');

and the value "Anno" is the output of my query.

I suppose that I've forgotten something, but I don't know what

Ciao Stefania