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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Binary Load with user input(urgent)

I want to do a binary load based on the input from the user. Whenever the file will be reloaded, a prompt should ask the user for input(a file name) which will set a variable(lets say vABC) containing file name. And then we should be able to do a inary load based on that variable name.

EX:

 

Binary

[$(=vABC).qvw]

Labels (1)
2 Replies
MayilVahanan
MVP
MVP

Hi

Try this script

LET vValue = Input('Enter filename', 'Input box');

Load

*

FROM  $(vValue);

But can't for binary load..

Because

Only one binary statement is allowed in the script and it can only be put as the first statement of a script.

Hope this helps you.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
swuehl
Champion III
Champion III

Not sure that this can easily be done, though you can use INPUT statement to query the user to input a value (i.e. the file name).

BINARY statement needs to be the first statement in the script, so no chance to use INPUT before that statement, and I haven't found a method to call INPUT as part of the binary statement itself.

Maybe you can work out a solution using a variable in your binary statement and setting the variable on opening the QV file (check out the command line options for that).

Regards,

Stefan