Hide Table Fields In QlikView Application

Introduction

In the QlikView application, the table fields will be hidden from using HidePrefix.

The following  is the basic procedure for hidding fields in a QlikView application.

Step 1:
Open the QlikView application

In this 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 to open the edit script window.

window of edit script

Then, this window will be opened.

window

Step 3: Open table files

Simply click on the table files to open the Excel files.

table files

Step 4: Open local files window

Then this window will be opened and in this window we upload an Excel file and click on the Open button.

Local Files

Step 5: Then the file wizard type window will be opened. Here you can see our Excel table and click on the Finish button.

file wizard

Step 6: Code of edit script and reload

After this step you can see this code in the edit script and reload it.

reload

Step 7: Save file

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

save file

Step 8: Sheet property window

The Sheet property window will be opened and simply click on the OK button.

Sheet Property

Step 9: Then this window will be opened.

main window

Step 10: Hide fields

Now the next step is to open the edit script and write the code of the edit script and again reload it.

code script

Now here we hide the fields that we want.

hide field

Step 11: Sheet property window

In this window, you will see the hidden fields and simply click on the OK button.

Example

I hid two fields in our source code, Title and Salary. You will then see that those two fields are not displaying.

Sheet Property1

Step 12: Open the table viewer

The next step is to open the table viewer from the file menu option and select table viewer.

table viewer

Then this window will be opened and click on the OK button.

view table

Step 13: Select list box

Do right-click anywhere in the blank sheet and select New sheet object-> List Box.

list box

Step 14: New list box

In this window, in the General tab you need to select a field expression and then this window will be opened; there will be a write a hide table field name and click on the OK button.

expression window

Then this window will be opened and click on the OK button.

exp window

Step 15: Then you will see the hidden table field will display.

main1

Step 16: If you want to change the label name of the hidden field then simply go to the property of this field.

property

Step 17: Then you can change the title name, in the General tab there is an option given for the title name. From here you can change the title name and click on the OK button.

title

Step 18: Now you can see the change title name of the field and it is the final window.

title1

So these are the basic steps for hiding table fields in a QlikView application.

Summary

This article described how to hide and show a table field.