topic Re: Binary load based on documentpath() in QlikView

Binary load based on documentpath()

Fri, 12 Jun 2015 14:22:03 GMT

Hello all,

I have split my development & production environment. When I copy a QV app from DEV to PROD then the binary load should know which data model (development or production) to use (see attachment for folder structure):

DocumentPath() like '*\Formeel*' then

Binary [..\..\..\5_datamodel\sales\formeel\dm_sales.qvw];

else

Binary [..\..\..\5_datamodel\sales\informeel\dm_sales.qvw];

end if

Needless to say this doesn't work else I would not post this . Who can help me?

Thanks in advance,
Marcel

Re: Binary load based on documentpath()

Clever_Anjos — Fri, 12 Jun 2015 14:30:15 GMT

Can´t do that

Binary command MUST be the very first command

Re: Binary load based on documentpath()

jonathandienst — Fri, 12 Jun 2015 14:30:27 GMT

Binary must be the first executable statement in the script, so I don't think that is possible. Perhaps someone has a smart workaround?

Re: Binary load based on documentpath()

swuehl — Fri, 12 Jun 2015 14:32:46 GMT

Maybe a solution based on Massimo's will work out:

Re: BINARY load with dynamic file name

Re: Binary load based on documentpath()

Fri, 12 Jun 2015 14:39:23 GMT

I was hoping that I could determine a part of the file to load.

binary '[..\' & if(documentpath() like '*production*', 'production', 'development') & '\datamodel.qvw';

But this doesn't work either...

Re: Binary load based on documentpath()

Fri, 12 Jun 2015 14:40:12 GMT

Hi Swuehl,

Restriction here I believe is that it needs to be in the same directory, which is not the case unfortunately...

Regards,
Marcel

Re: Binary load based on documentpath()

swuehl — Fri, 12 Jun 2015 14:51:13 GMT

Not sure if I understand your limitation. I don't think the included script file needs to be in the same directory.

You just need to create a script file with the binary statement once for DEV, once for PROD, and have the UI QVW use a relative path to that qvs.

Re: Binary load based on documentpath()

Anonymous — Fri, 12 Jun 2015 14:57:40 GMT

Binary load should be first executable statement .Only one binary load should be used in one application .

Re: Binary load based on documentpath()

Fri, 12 Jun 2015 15:09:10 GMT

Okay!! Yes, that’s a proper work-around!

Thanks (can’t believe the answer is so easy…)

Regards,

Marcel

Re: Binary load based on documentpath()

Fri, 12 Jun 2015 17:01:27 GMT

May be try with Environment variable,