Buffer Load Statement in QlikView

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



Now data has been imported from the database.



Step 9: Use buffer load and execute edit script

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



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.



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.



Now here you see the buffer load execution.



Step 12: Sheet property Window

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



Step 13: Select table box

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



Step 14: New table box

Here select fields for displaying data in tabular form.

Now you can see the table box.



Step 15: Main window

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



Here you see the location of the buffer load statement.

Here you see the default QVD buffer file.

Step 16: Open edit script again

After writing this code.

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



Summary

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