Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Parameters in script (prompt)

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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');


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
swuehl
MVP
MVP

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;

zagzebski
Creator
Creator
Author

Thanks much!

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

Gysbert_Wassenaar

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');


talk is cheap, supply exceeds demand
zagzebski
Creator
Creator
Author

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?

zagzebski
Creator
Creator
Author

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

lfalmoguera
Creator
Creator

Is there anyway to maket thant input box bigger?

 

prompt.png