topic dynamic binary load in QlikView

dynamic binary load

Thu, 10 Sep 2009 17:09:29 GMT

Hi all,

can anyone tell me if it is possible to load (by means of binary statement) a variable .qvw file?

Something like

Binary $(var);

where 'var' value is specified in qv.exe command line.

Thanks a lot!

dynamic binary load

Thu, 10 Sep 2009 17:19:58 GMT

You can invoke QV through a command line and pass the name and value of a variable (declared in the document) using the '/V' switch. For example

/VvExport=1

will pass a value of 1 to be assigned to the variable vExport in the document.

Regards,

Gordon

dynamic binary load

Thu, 10 Sep 2009 17:52:55 GMT

Hi Gordon,

thanks for your replay.

It's exactly what I did, but it's not working.It seem to me that maybe an order in the switch list, for the command line.

This is my code

Binary "$(reg)";
 ..............................
Let reg = $(VAR);

and command line in batch file is

C:\Program Files\QlikView\Qv.exe /r C:\qlik\myDoc.qvw /vVAR='C:\qlik\myETL.qvw '

Have you any suggestion?

Thanks!

dynamic binary load

Thu, 10 Sep 2009 18:12:49 GMT

Roberta,

Try removing the quotes from both the command string and also from the binary statement.

Regards,

Gordon

AW:Re: dynamic binary load

biester — Thu, 10 Sep 2009 18:21:42 GMT

Hi,

it's working fine with me (without qoutes in the binary statement as Gordon says). But first you have to add the variable manually to your myDoc.qvw- The "Let reg = $(VAR)" is not enough, moreover, it's useless here, I'd say.

Rgds,
Joachim