User preferences are settings that concern the way the user works and that are stored on the computer, not in the document file.
User Preferences: General
- Show System Fields: If selected, the System Fields will be included by default in all listings of field names.
- Show System Variables: If selected, the System Variables will be included by default in all listings of variables.
- Use Sounds: Enables the built in sound effects of QlikView.
- Remove Unused Bitmaps: Bitmaps used in sheets and sheet objects are normally retained in the document even if their use is turned off. Check this alternative to have them automatically removed.
- Scramble Connect User Credentials: Check this alternative if the connect statement wizard should mask the connect statements by scrambling user ID and password.
- Remember Login Credentials until QlikView exits: QlikView can cache the UserID and password for QlikView documents requiring login that have been opened for the duration of a QlikView-session. By deselecting Remember Login Credentials until QlikView exits, the user will be prompted to login each time a document is reopened.
- Keep Progress Open after Reload: Checking this box will keep the Script Execution Progress dialog open after the script has finished reloading.
- Horizontal Scroll bar: If this setting is on, a horizontal scroll bar will appear along the edge of the sheet whenever the positioning or sizing of sheet objects cannot be fully accommodated horizontally inside the application window.
- Vertical Scroll Bar: As the above setting, but pertaining to the vertical.
- Resize Window to Documents: With this alternative checked, the size of the QlikView window is determined by the size of the document, i.e. the size of the QlikView window at the time the document was saved.
- Keep Orphaned QVD Buffers: This setting overrules the normal procedure whereby any automatically created QVD files are purged immediately after script execution, provided that the document that created them is no longer available. This setting should normally be left unchecked.
- Flush script log after each write: For performance reasons, the script log is normally not written to disk after each individual statement. By selecting this script box it will be. This may be useful if other programs are used to monitor the script execution via the log. However, using this setting may significantly increase script execution time in cases where the script contains large numbers of statements.
- Re-open Script Dialog After Script Execution from Dialog: If the script is executed from within the Edit Script dialog and this check box is marked, the dialog will be re-opened after script execution.
- Show Getting Started Wizard When Creating New Document: Opens the Getting Started Wizard which guides through the steps of creating a new document based on a single Excel sheet.
- Purge Orphaned QVD Buffers Now: Click this button to perform a manual purge of orphaned QVD buffers that have been retained by the setting Keep Orphaned QVD buffers above.
- Most Recently
Used Files: This group is used for controlling
the list of recently opened QlikView files in the File
menu and on the Start Page.
- Under In Menu the number of recently used files listed in the File
menu can be changed. The default is 8.
- Under On
Startpage the number of recently used files listed on the Start Page can be changed. The default
These changes take effect after restart.
- If the alternative Show Full Path in
Menu is checked, the File
menu will be widened as necessary to show full paths in the list of recently
- Clicking the
Remove URLs button will remove
any URLs from the list of most recently used files.
- Under In Menu the number of recently used files listed in the File menu can be changed. The default is 8.
- Logfile Encoding: In this group it is possible to set the character set for the log file. The default setting is ANSI, but it is possible to check the option Unicode instead.
Sets the default selection style. QlikView supports a number of different ways of presenting data and making selections in list boxes and multi boxes. The QlikView Classic, Corner Tag, LED and Led Checkboxes styles all use color coding for indication of selected, possible and excluded values. The Windows Checkboxes style and the LED Checkboxes style mimic the standard Windows interface with a check box at each value. This default can be overridden for a specific document by means of a corresponding setting under Document Properties: General). There are limitations as to the behavior of certain macro triggers when working with documents on QlikView Server.
Selection Color Scheme
Sets the default selection color scheme. When using the selection styles based on color, there are a number of different color schemes available. The color scheme (green for selected, blue for locked etc.) cannot be changed, but variations of tone and intensity are possible. This default can be overridden for a specific document by means of a corresponding setting under Document Properties: General).
- Preferred Selection Style
Interface Language: Press the button to open the Select
Interface Language dialog. In this dialog all language versions
of QlikView that are available on the computer will be listed (Various
language versions are included as .dll files at the time of installation). For a full list of the supported languages, see Supported languages. After selecting a new language, QlikView must be restarted to effect
the change. The change affects both the language of the program user interface
and the language of the online help, provided that the appropriate help
files are also available on the computer.
The interface language can also be set by modifying the
settings.inifile, found in
C:\Users\username\AppData\Roaming\QlikTech\QlikView. Edit the setting InterfaceLanguage and set it to a supported language.
- Bookmark Popup Timeout (s): Check this alternative and enter a time delay to have bookmark pop-up windows automatically close after a set number of seconds.
- Use WebView in Layout: Toggles WebView mode, which uses the internal web browser in QlikView to display the document layout as an AJAX page, on and off.
- Search Settings: In this group settings are made for default search mode.
- Include Excluded Values in Search
There are two ways to interpret text search: it is possible to search either among optional values, or among all values, i.e. include the excluded values in the search. Enable this option to do the latter. This default value can be overridden on sheet object level.
- Preferred Search Mode
The default search mode for text search in list boxes, multi boxes etc. can be set in this drop-down box. The default only applies when the user starts typing directly and do not use any of the menu choices or keyboard shortcuts for starting the search. It is possible to override this setting by selecting a different setting on sheet object level.
- Use Previous
The search mode of the last completed search will be used.
- Use Wildcard Search
The initial search string will be two wildcards with the cursor between them to facilitate a wildcard search.
- Use Normal Search
No additional characters will be added to the search string. Without wildcards, a Normal Search will be made.
- Include Excluded Values in Search
- Max Values in Current Selections: Specify the maximum number of distinct selected values here to be shown in the current selections dialog and in the selection stamps in printouts. When more values are selected they will only be specified as ‘x values of y’ for the respective field.
- Working set limits %: This control sets the minimum and maximum of the physical amount of
RAM that can be used by an application. This way it is possible to control
if an application can be swapped out of physical memory or not. However,
there are no guarantees that the operating system can serve the process
with the amount of memory set here.
Using too high settings will degrade the performance of other processes on the computer, this may however be desirable if the computer is dedicated for QlikView.
Do not change these settings unless you are well acquainted with Windows Virtual Memory Manager! Read more about working sets in the Microsoft Windows documentation.
The settings are:
Sets the minimum amount of memory, in percentage, to be allocated to the application/process.
Sets the maximum amount of memory, in percentage, to be allocated to the application/process.