topic Binary Load in QlikView

Binary Load

jagannalla — Thu, 16 Jun 2011 07:53:40 GMT

Hi,

Can anyone explain me use of binary load with example.

Binary Load

matt_crowther — Thu, 16 Jun 2011 08:04:37 GMT

There are a few key things to note about the Binary Load statement:

1. You can only use it as the first statement of a load script.

2. There can only ever be one binary load per .qvw.

In essence what a Binary Load does is load all the data and Access permissions of one .qvw into another eg:

Binary C:\Docs\MyFile.qvw;

From there you can then add additional traditional load statements to build on the model.

It has several uses; protecting entire scripts - you have your load script in one secure .qvw and your dashboard in a second; the only script that then has to be presented to the user is the Binary statement (Qliktech themeselves use this in their sensitive documents as it obviously hides connection strings etc. Also as it's literally a load of the QV memory for that .qvw it is very quick for sharing the same source data.

Hope that helps,

Matt - Visual Analytics Ltd

Binary Load

jagannalla — Thu, 16 Jun 2011 09:17:12 GMT

Matt,

Thanks Matt to explian briefly about Binary load.

I tried with few examples but, it is working after saving the 1st .qvw file.

Binary Load

Wed, 07 Dec 2011 16:51:59 GMT

Thank you Matt... This was very helpful information

Re: Binary Load

Fri, 21 Sep 2012 15:22:46 GMT

Hi Matthew

Can we say using binary load instead of qvd load will help for faster access of dat in the application? If yes why?

Thanks for you time.

Max

Re: Binary Load

Anonymous — Thu, 31 Jan 2013 06:17:23 GMT

Hi Max,

Using the binary load and qvd load have it's own significance. It's scanario based. As you might be knowing the limitation of binary load in only one per qvw application. if you have more than one application to load then you will need to go for qvd load only, binary wont help.

Best,

Skumar