topic Re: Binary Load with user input(urgent) in QlikView

Binary Load with user input(urgent)

Mon, 05 Nov 2012 13:40:35 GMT

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]

Re: Binary Load with user input(urgent)

MayilVahanan — Mon, 05 Nov 2012 14:14:16 GMT

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.

Re: Binary Load with user input(urgent)

swuehl — Mon, 05 Nov 2012 14:17:45 GMT

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