Is binary load supported in Qlik Sense ?

[Oleg_Troyansky]

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..."

[jaimeaguilar]

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 · Accepted solution]

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:

Argument	Description
file	The 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.

Examples

Binary customer.qvw;
Binary c:\qv\customer.qvw;

[#4]

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.

[#5]

Hi, how to open scripting part in qliksense?

plz reply some shortcuts n qliksense

[#6]

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]

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

section access not work in qlik sense

[#8]

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]

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

[#10]

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;