Buffer Load Statement in QlikView

Introduction

This article explains how the buffer load statement works in a QlikView application and how to load data.

There are basic steps for the buffer load statement. So let's start with these steps.

Step 1: Open the QlikView application

In the first step you need to open the QlikView application then go to "File" -> "New" then this window will be opened.

After clicking New option

Step 2: Open Edit Script

The second step is open the edit script window from, "File" -> "Edit Script".

window of edit script

  • Then this window will be opened.

    window

Step 3: Select Database

The third step is to select the database from the data tab and click on the Connect Button.

select database

Step 4: Data link property window

In this window we select SQL Server and click on the Next Button.

data link

Step 5: Connection tab


In the connection tab, enter the server name and user name and password and select the database from your server and click on the Ok button.

ok button

  • Then you find that the test connection succeeded.

    Confirm box

Step 6: Connection to SQL Server

Now you will see the connection to SQL Server as in the following:

connection

Step 7: Select database

Now the next step is to select the database for loading the data.

data

Step 8: Import data

Now the next step is to import data from the database and click on the Ok button.

import data

Now data has been imported from the database.

main data

Step 9: Use buffer load and execute edit script

Now we execute the buffer load statement in the QlikView edit script and reload it.

reload

Step 10: Save QlikView file

After reloading the edit script, the next step is to save the QlikView file and click on the Save button.

save file

Step 11: Script execution progress

Then the script execution progress window will be opened. Enther the required login Id and password and click on the OK button.

execution

Now here you see the buffer load execution.

Script execution

Step 12:
Sheet property Window

After this process, the sheet property window will be opened and click on the Ok button.

main sheet

Step 13: Select table box

Now select the table box for displaying data in tabular form.

table box

Step 14: New table box

Here select fields for displaying data in tabular form.

table

Now you can see the table box.

tab

Step 15: Main window

In the main window, in the menu bar go to "Settings" -> "User Preferences".

main window

Here you see the location of the buffer load statement.

location

Here you see the default QVD buffer file.

buffer file

Step 16: Open edit script again

After writing this code.

Stale after 1 hour. After one hour it executes automatically.

buffer load

Summary

This article described how the buffer load statement works and how to execute a QVD file.