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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Michiel_QV_Fan
Specialist
Specialist

Need help: Input box value in a load script

I'm trying to figure out how to creat a user select value as input for partial reload.

The helptext for input box is unclear for me.

Has anyone an other example?

Thanks.

1 Solution

Accepted Solutions
Not applicable

Create an input box on the QV sheet (not the script), linked to a variable. The user can set the variable value in this box.

Then look up this variable value in the script...

if (isnull(varDataLoad)) then
let varDataLoad = 4;
end if ;

Note the default value '4' used for when that variable has no value.

If you want to have a message box pop up to the user, add this line above the if( )...

let varDataLoad = input('Prompt', 'Message box title');

Which you use will depend on if you have any automated reloads - they can't respond to prompts and I don't know what happens to the input message box.

View solution in original post

1 Reply
Not applicable

Create an input box on the QV sheet (not the script), linked to a variable. The user can set the variable value in this box.

Then look up this variable value in the script...

if (isnull(varDataLoad)) then
let varDataLoad = 4;
end if ;

Note the default value '4' used for when that variable has no value.

If you want to have a message box pop up to the user, add this line above the if( )...

let varDataLoad = input('Prompt', 'Message box title');

Which you use will depend on if you have any automated reloads - they can't respond to prompts and I don't know what happens to the input message box.