Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use Input in a script...

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

1 Reply
Not applicable
Author

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