Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Oleg_Troyansky
Not applicable

Is binary load supported in Qlik Sense ?

Folks,

I'm playing with Qlik Sense, and I was wondering if BINARY load was supported in Sense?

I'm trying to load a data model using Binary, and I'm getting an error "Cannot Open File..."

1 Solution

Accepted Solutions
Chip_Matejowsky
Not applicable

Re: Is binary load supported in Qlik Sense ?

Hi Oleg,

Yes you can use a Binary Load to load data from another Qlik Sense app or QlikView document. The information below is taken directly from the Qlik Sense Help regarding Binary:

Binary

The binary statement is used for loading the data from another Qlik Sense app or QlikView 11.2 or earlier document, including section access data.

Syntax:

binary file

file ::= [ path ] filename

Arguments:

ArgumentDescription
fileThe name of the file, including the file extension .qvw or .qvf.
path

The path to the file, either:

  • absoluteExample: c:\data\
  • relative to the app containing this script line.Example: data\
  • a folder data connection.Example: 'lib://Table Files/'

Only one binary statement is allowed in the script and it must be the first statement of the script.

Binary customer.qvw;

Binary c:\qv\customer.qvw;

Sr. Technical Support Engineer with Qlik Support
26 Replies
jaimeaguilar
Not applicable

Re: Is binary load supported in Qlik Sense ?

Hi,

I tested this some days ago, and yes Binary Load is supported in Sense, either from QVFs and even QVWs, so you cn import data models that you already have and create new visualizations within Sense,

regards

Chip_Matejowsky
Not applicable

Re: Is binary load supported in Qlik Sense ?

Hi Oleg,

Yes you can use a Binary Load to load data from another Qlik Sense app or QlikView document. The information below is taken directly from the Qlik Sense Help regarding Binary:

Binary

The binary statement is used for loading the data from another Qlik Sense app or QlikView 11.2 or earlier document, including section access data.

Syntax:

binary file

file ::= [ path ] filename

Arguments:

ArgumentDescription
fileThe name of the file, including the file extension .qvw or .qvf.
path

The path to the file, either:

  • absoluteExample: c:\data\
  • relative to the app containing this script line.Example: data\
  • a folder data connection.Example: 'lib://Table Files/'

Only one binary statement is allowed in the script and it must be the first statement of the script.

Binary customer.qvw;

Binary c:\qv\customer.qvw;

Sr. Technical Support Engineer with Qlik Support
Not applicable

Re: Is binary load supported in Qlik Sense ?

Using Desktop v.96, I tested BINARY load and it worked fine. Be sure you fully qualify the directory of the QVF or QVW file you are pointing to.

I also tested the ability to add additional data within the Sense script after the binary load. So if you wanted to augment the QVW's data model with additional data (of course you will have to be sure that the new data properly "links up" to your QVW data model), you could use the QVW data model as a baseline and add to it from within Sense. Furthermore, when you do a reload within Sense, it reloads the data from the QVW as well as the data retrieved within Sense. Thus, you have some nice opportunities for reuse here.

Not applicable

Re: Is binary load supported in Qlik Sense ?

Hi, how to open scripting part in qliksense?

plz reply some shortcuts n qliksense

Not applicable

Re: Is binary load supported in Qlik Sense ?

There is a Navigation icon in the upper left corner of the screen that looks like a compass. Select that and the Data Load Editor drop down option. If you select the rectangles to the far right of the option, it will open the script editor in a separate tab. The data model viewer is in this set of options as well.

SunilChauhan
Not applicable

Re: Is binary load supported in Qlik Sense ?

Binary load can be used by need to type it mannually in qliksense

section access not work in qlik sense

Not applicable

Re: Is binary load supported in Qlik Sense ?

In a QlikSense Server, what user will be used to perform the Binary Load for a QVW that has section access defined? I am trying to load one with Section Access defined and it is failing. I assume it is due to a specific user (the loading user) not being in the Section Access.

Bjorn_Wedbratt
Not applicable

Re: Is binary load supported in Qlik Sense ?

Hi Brian,

Try and add the user INTERNAL\SA_SCHEDULER as ADMIN in your Section Access to be able to reload it in Qlik Sense.

Best

Bjorn

Not applicable

Re: Is binary load supported in Qlik Sense ?

That did not work. Added requested user. Reloaded document under qlikview. Moved qvw after reload to QlikSense direction location. Still receive data load failure.

Example of section access used:

Section Access;

LOAD * INLINE [

     ACCESS, NTNAME, ACCESSCODE

     ADMIN, INTERNAL\SA_SCHEDULER

];

Concatenate

LOAD * RESIDENT UserAccessInfo;

Section Application;

DROP Table UserAccessInfo;