Resident Load in QlikView

Introduction

In QlikView, Resident Load can be used to load data from a previously loaded table. In Resident Load, we can do a calculation or transformation. It is very simple to load an existing field and table also. It is a highly important feature of QlikView because by using Resident Load, we perform a calculation on an existing field and table also.

In this article, I explain how Resident Load an existing field and successful table and perform a calculation on this field and load data from the previous successful field.

So let's start with the procedure.

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.

new option

Step 2: Open Edit Script

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

win of edit

  • Then this window will be opened.

    window1

Step 3: Click on table files

tablef

Now open table file and click on the Open button.

local file

Step 4: File wizard type

Then this window will be opened. Here you can see your table file table and click on the Finish button.

File wizard

Step 5: Code of edit script

Now, in edit script web file upload successfully and reload it.

reload

Step 6: Save file

The next step is we need to save our QlikView file.

save file

Step 7: Sheet property window

The sheet property window will be opened. In this window you add fields that you want to display as a table and click on the OK button.

sheet

Step 8: Select table

In menu bar, there is option of layout then, select layout->New sheet object->table box.

table box

Step 9: New table box

In this window we select fields and click on the OK button.

field

Now you can see data will be uploaded from data (Excel) files.

data

Step 10: Open edit script

Now the next step is open edit script again and perform code for Resident Load and then reload it.

reloading

Step 11: Sheet property window

The sheet property window will be opened. In this window you add fields that you want to display as a table and click on the OK button.

sheet1

Step 12: Select table

In the menu bar, there is an option for layout; select layout->New sheet object->table box.

table box

Step 13: New table box

In this window we select fields and click on the OK button.

field1

Now you can see Resident Load loads data from an existing field and perform the calculation. It will show the percentage of population with rank.

data1

If you select any data from the table then it shows the country name, percentage of population and date and so on.

selected data

Summary

This article provided an introduction yo Resident Load in QlikView applications and how it works with an existing table and performs calculation.