Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
MVP & Luminary
MVP & Luminary

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

Oleg Troyansky

Masters Summit for Qlik is going virtual! Dec 16th - I'll teach Performance Tuning

1 Solution

Accepted Solutions
Highlighted
Support
Support

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

View solution in original post

29 Replies
Highlighted
Partner
Partner

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

Highlighted
Support
Support

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

View solution in original post

Highlighted
Not applicable

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.

Highlighted
Not applicable

Hi, how to open scripting part in qliksense?

plz reply some shortcuts n qliksense

Highlighted
Not applicable

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.

Highlighted
Champion
Champion

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

section access not work in qlik sense

Highlighted
Not applicable

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.

Highlighted
Support
Support

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

Highlighted
Not applicable

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;