topic How to define a predefined list value in QlikView

How to define a predefined list value

Wed, 16 Mar 2011 15:00:37 GMT

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

How to define a predefined list value

IAMDV — Wed, 16 Mar 2011 15:15:57 GMT

Please can you post an example?

How to define a predefined list value

Wed, 16 Mar 2011 15:56:16 GMT

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

How to define a predefined list value

boorgura — Wed, 16 Mar 2011 16:02:16 GMT

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.

How to define a predefined list value

Wed, 16 Mar 2011 16:16:36 GMT

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