Databases Reference
In-Depth Information
Better "Save" than sorry
By default, when QlikView encounters errors during the
reload of a document, it automatically closes the document and
reloads the last saved version of the file. It can be a frustrating
experience when you have just written a lot of script, only to
see all of it lost because you forgot a semicolon somewhere.
One way to avoid this problem is by always first saving your
script before reloading. This can be done by going to
File |
Save Entire Document
from the menu, by pressing
Ctrl
+
S
, or
by clicking on the
Save
icon in the toolbar.
Another more fail-safe way is to set QlikView to automatically
save the file before each reload. To do this, close the script
editor and open the
User Preferences
menu by selecting
Settings | User Preferences
from the menu, or by pressing
Ctrl
+
Alt
+
U
. In the menu, select the
Save
tab and tick the
checkbox labeled
Save Before Reload
. It is also advisable to
tick the checkbox
Use Backup
and set the field
Keep Last
Instances
to
5
. This last option ensures that the last 5 versions
of the QlikView file are kept.
To run the script and see what the result is, follow these steps:
1. Select
File
|
Reload
, press
Ctrl
+
R
, or click the
Reload
button on the toolbar
to reload the script.
2. When the script has finished loading you will see the
Sheet Properties
dialog, click on
OK
to close it.
You will notice that two of our list boxes have gone missing,
Aircraft Group
and
Aircraft Type
. This has happened because the fields that were used for these list
boxes were removed from the data model.
Let's remove the two list boxes and replace them with a single Aircraft multibox, by
following these steps:
1.
Right-click on the list box labeled
(unavailable)[Aircraft Group]
and select
Remove
. As this is a linked object, select
Delete All
to remove the object
from all sheets.
2.
Repeat the previous step for the list box labeled
(unavailable)[Aircraft Type]
.