topic Parameters in script (prompt) in QlikView

Parameters in script (prompt)

zagzebski — Fri, 15 Feb 2013 16:31:05 GMT

Is there any way in a QlkView script that you can prompt the user to enter a variable before the script with continue?

Re: Parameters in script (prompt)

swuehl — Fri, 15 Feb 2013 16:32:21 GMT

Try the system function Input():

Input(str cue [, str caption])

This function can be used in the script only and opens an input box that prompts the user for a value during the script execution. The parameters cue and caption are used as message and caption texts, respectively. The function returns the entered value.

The input box function returns NULL if the dialog is cancelled, closed or cannot be shown.

Example:

Load
Input('Enter value', 'Input box') as v,
Recno () as r
autogenerate 3;

Re: Parameters in script (prompt)

zagzebski — Fri, 15 Feb 2013 16:48:11 GMT

Thanks much!

So is there no way to use this as part of a SET function?

Re: Parameters in script (prompt)

Gysbert_Wassenaar — Fri, 15 Feb 2013 16:50:28 GMT

Nope, you need to use LET if you want to put a value from an input box in a variable:

LET vMyVar = Input('Enter value', 'Input box');

Re: Parameters in script (prompt)

zagzebski — Fri, 15 Feb 2013 17:13:42 GMT

So this doesn't seem to work

LET vMyVar = Input('Enter value', 'Input box');

Load

vMyVar,

Field1,

Field2

from T1;

Should I be able to now read the variable into the load file?

Re: Parameters in script (prompt)

zagzebski — Fri, 15 Feb 2013 17:33:01 GMT

Forget it. Had a syntax error. This works great. Thanks so much.

Re: Parameters in script (prompt)

lfalmoguera — Thu, 01 Oct 2020 16:18:04 GMT

Is there anyway to maket thant input box bigger?