topic Use Input in a script... in QlikView

Use Input in a script...

Tue, 10 Nov 2009 16:34:35 GMT

Hi,

I would like to use Input in a script. I do this:

load
`inv_id`,
Year as Input_Year
resident Sales
where Year=Input('Saisir l année','Zone de saisie');

With this script, i would like to reduce data with the yaer's value input by user.

But when i reload the script, i got the prompt several times.

It is normal?

Thanks

Tue, 10 Nov 2009 16:53:27 GMT

You should use

LET inputYear = Input('Saisir l'&chr(39)&'année','Zone de saisie');

Then

Load

xxxxxxx,yyyyy

resident Sales where Year = $(inputYear)

It is asking you more than once because it evaluates each record. The solution I gave you should solve that issue.

Regards,

Sébastien