topic Re: binary? in QlikView

binary?

Anonymous — Wed, 08 Apr 2015 13:15:46 GMT

If i load a application through binary(qvw)

what are the changes will be there ?

whether variables will get dropped ?

any changes in dm ? or any changes in tables ?

Re: binary?

sunny_talwar — Wed, 08 Apr 2015 13:19:47 GMT

I am not sure about the variables (you can do a test load), but I am pretty sure that you won't see anything in your front end. Everything will have to be recreated on the front end of the application. Binary load just brings the database with the data structure intact into another application, but front end objects are not carried over.

HTH

Best,

Sunny

Re: binary?

Wed, 08 Apr 2015 13:22:47 GMT

Through binary load, are loaded only the data contained in qvw, not variables or objects present in the user interface.

Loads entire structure of the tables contained in qvw loaded via the binary load

Regards

Re: binary?

Anonymous — Wed, 08 Apr 2015 13:25:12 GMT

in the backend create variables will work or not ?

Re: binary?

its_anandrjs — Wed, 08 Apr 2015 13:28:10 GMT

Hi,

If you load the QVW file as binary file you get the data model in the application but variables you have to create. And challenge there is need to check the synthetic keys and the tables might be same field are available.

Regards,

Anand

Re: binary?

Anonymous — Wed, 08 Apr 2015 13:35:15 GMT

then my question is

if i create variable in backend like

let vp =peek(date)

then it will not come after binary load so again i have to creat in app na

thats double work

Re: binary?

Wed, 08 Apr 2015 13:37:47 GMT

Exactly, you have to create variables although in the script that loads the qvw through binary load.

Re: binary?

sunny_talwar — Wed, 08 Apr 2015 13:39:59 GMT

Just performed a test and script variables also don't carry over.

PFA

Re: binary?

Wed, 08 Apr 2015 13:42:29 GMT

If qvw are on the same server and you need the objects of a qvw to another, you can use other techniques to include objects from various qvw.

See QlikView Mashups at: http://www.qlikblog.at/2343/

Re: binary?

Anonymous — Wed, 08 Apr 2015 13:44:12 GMT

what about synthetic key and all

early i have removed

after loading through binary whether will get change or it looks good?

Re: binary?

its_anandrjs — Wed, 08 Apr 2015 14:00:31 GMT

Hi,

Yes you right but better you copy and paste the variables from the script part into new qvw. And for synthetic keys do not worry about that just load the tables and remove it from the load script. And by this you also know what are the synthetic keys are created in the QVW application.

Regards

Anand

Re: binary?

Anonymous — Wed, 08 Apr 2015 14:22:33 GMT

Hi anand,

Thank u very much for uy r wonderful answers

if u have any sample application for above queries could pls share it here

because as u told again i have to pull all data in to final app and need to remove synthetic key .

it means i need to copy all script from datamodel to final app again ?

am i right?

Re: binary?

its_anandrjs — Wed, 08 Apr 2015 14:42:34 GMT

Hi,

No you have to load the QVW file as binary load into another QVW and do not need to write the script again there. Example check this two files File1.qvw and File2.qvw in File2.qvw i binary load the File1.qvw with one table and in file2.qvw there is one binary load of the File1.qvw. Check file1.qvw for the binary load.

Regards

Anand

Re: binary?

Anonymous — Wed, 08 Apr 2015 15:09:47 GMT

Just to add..here from already posted answer, which might give you more clarity:-

Binary load is the load performs for the QVW file means when any QVW file loads into the another QVW and load all structure from another QVW to another QVW. And at a time only single QVW is loaded as binary file.

For example, our dashboards and reporting apps are typically built in 3 stages... we use a handful of apps to acquire and transform data from various sources and export the raw but "formatted" data in QVDs. In a second stage app, we load the qvds into one data model, perform any additional data transformation on the full set. Then finally, the third and final stage is the "front-end" interface where we load the qvw (called a binary load) into an app where the dashboard, reporting and visualizations are created.

For your clarification since you don't have any syn key in previously loaded QVD, of course you wont get here in new as well. Please let me know if your question is clarified while marking it as answered or shoot your next query.

Best Regards,

S Kumar

Re: binary?

maxgro — Tue, 14 Apr 2015 17:33:24 GMT

tst