• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Binary Load in Qlikview

What is Binary Load?

Binary Load replicates the data model of an existing QlikView document into another QlikView document without accessing the original data source. Once the data model gets replicated into another QlikView document, it can be manipulated further, integrated into a bigger data model

Binary Load

The binary statement is used for loading the data from another QlikView document, including section access data.

-It does not load the layout information or variables.
-Only one binary statement is allowed in the script.
-It can only be put as the first statement of a script.

Ex:
Binary Transact.csv;

Implementation of Binary Load

Implement this binary load to a new QlikView document.

Create a new QlikView document and save it as “Fraud.qvw”

Open Edit Script window (Press Ctrl + E)

Click on QlikView File button and locate “Sales.qvw”

Qlikview Tutorials

You can see that a new script statement is added at the top of the active script tab, which is “Binary sales.qvw”

qlikview tutorials

Add both fraud tables to the data model as we normally do. After reloading the script, the data model will be seen in a new QlikView document along with 2 additional Fraud tables. Following is the snapshot of the table viewer:

Qlikview Tutorials

Advantages of using Binary load:

  • It saves the time required to load a complete new model from data source or QVD Thus, speeds up the reload process.
  • It is useful when applying security using Section Access. The security specifications can be coded in a separate QVW and then add that QVW using Binary Load in all the other documents.
  • Binary load is the fastest way to load data into a QlikView document.

For indepth understanding of Qlikview click on

Dimensions in Qlikview

Incremental Load in QlikView with Example

NULL values In QlikView

Different types of Loads in QlikView

Qlikview Objects

Summary
Review Date
Reviewed Item
Binary Load in Qlikview
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Binary Load in Qlikview"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.