Input variables before loading

[Anonymous]

Dear specialits,

Is it possible to let the load script with input variables?

What I want is that when you open the Qlikview document there will be a input filed to fill in the variable.
Then make a Load-button, when you press the button the loaad script will be using the variabel.

Example:

Input vYear = 2009

And then use vYear in the loadscript like :

Load *
SQL SELECT
FROM TABLE
Where Year = '$(vYear)'

How do I set the variable (vYear) before loading?

[#2]

Hey Glyn,

I added the following to my script and it worked for me.

Let vSystemID=Input('Enter required System ID', 'System ID');

In addition, you have to create your variable (Settings - Variable Overview).

When starting a reload, an Input box pops up before loading any data:

I hope this is helpful.

Regards,

Daniela

[#3]

Thanks very much