IntroductionIn 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 applicationIn this step you need to open the QlikView application then go to File-> New then this window will be opened.Step 2: Open edit scriptThe second step is to open the edit script window.Then, this window will be opened.Step 3: Open table filesSimply click on the table files to open the Excel files.Step 4: Open local files windowThen this window will be opened and in this window we upload an Excel file and click on the Open button.Step 5: Then the file wizard type window will be opened. Here you can see our Excel table and click on the Finish button.Step 6: Code of edit script and reloadAfter this step you can see this code in the edit script and reload it.Step 7: Save fileThe next step is we need to save our QlikView file.Step 8: Sheet property windowThe Sheet property window will be opened and simply click on the OK button.Step 9: Then this window will be opened.Step 10: Hide fieldsNow the next step is to open the edit script and write the code of the edit script and again reload it.Now here we hide the fields that we want.Step 11: Sheet property windowIn this window, you will see the hidden fields and simply click on the OK button.ExampleI hid two fields in our source code, Title and Salary. You will then see that those two fields are not displaying.Step 12: Open the table viewerThe next step is to open the table viewer from the file menu option and select table viewer.Then this window will be opened and click on the OK button.Step 13: Select list boxDo right-click anywhere in the blank sheet and select New sheet object-> List Box.Step 14: New list boxIn 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.Then this window will be opened and click on the OK button.Step 15: Then you will see the hidden table field will display.Step 16: If you want to change the label name of the hidden field then simply go to the property of this field.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.Step 18: Now you can see the change title name of the field and it is the final window.So these are the basic steps for hiding table fields in a QlikView application.SummaryThis article described how to hide and show a table field.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: