topic Re: evaluate function during binary load in QlikView

evaluate function during binary load

chrweber — Tue, 05 Dec 2017 08:20:25 GMT

Hello,

I wish to do the following

Binary GetRegistryString('HKEY_CURRENT_USER\Environment','QVWLOCATION');

but I fail to get that function to evaluate.

Can you please help me?

Best Regards

Re: evaluate function during binary load

techvarun — Tue, 05 Dec 2017 08:37:32 GMT

What is your exact requirement?

You cannot use GetRegistryString(Or any other function) in a Binary statement.

Re: evaluate function during binary load

chrweber — Tue, 05 Dec 2017 09:13:49 GMT

That's a pity.

There is probably no way to get that evaluation in before the binary

Re: evaluate function during binary load

Colin-Albert — Tue, 05 Dec 2017 09:41:16 GMT

A binary load simply loads all data from one qvw into your application.

The only parameter you can specify for a binary load is the path & filename for the QVW. You cannot use script functions to determine the path for your binary load.

After the binary statement, which must be the first line of your script, you can then add other script commands.

Binary ‒ QlikView

Re: evaluate function during binary load

marcus_sommer — Tue, 05 Dec 2017 13:52:23 GMT

Maybe this is helpful: Re: BINARY command to be constructed dynamically.

- Marcus

Re: evaluate function during binary load

chrweber — Tue, 05 Dec 2017 14:13:51 GMT

That works but suffers from the limitation, that I cannot set the variable prior to the loading.

Re: evaluate function during binary load

slaheddinekeyru — Tue, 05 Dec 2017 14:23:34 GMT

I think that you have to set the variable in the qvw that is called by the Binary Load.

For example if you are loading the "test.qvw" file in Binary mode try to set your "GetRegistryString(Or any other function)" in the test.qvw file.

Re: evaluate function during binary load

marcus_sommer — Tue, 05 Dec 2017 14:58:15 GMT

What is the use-case behind this question? That each user gets his own dataset? Maybe there are alternatives for it, for example by using Section Access.

- Marcus

Re: evaluate function during binary load

chrweber — Wed, 06 Dec 2017 07:26:35 GMT

The location of the .qvw ist machine dependent, querying that during load path would the elegant solution.

Setting variables during deployment is a little cumbersome.

Re: evaluate function during binary load

marcus_sommer — Wed, 06 Dec 2017 08:21:33 GMT

Such a workflow is rather uncommon. Does this deploying of individual qvw's going on local storages or on a network-storage? What is the benefit against the more "classical" ways?

- Marcus

Re: evaluate function during binary load

chrweber — Wed, 06 Dec 2017 11:22:12 GMT

any storage location is possible and the binary load is the first action after deployment