QlikView Tutorial

WHAT IS QLIKVIEW AND ITS COMPONENTS

QlikView does in-memory data processing, data integration and stores them. It can read data from files and relational databases. Supports creation and consumption of dynamic apps. It makes the data presentation in an interactive way.

QlikView has 3 major components:

1. QlikView Desktop: It is a development tool
2. QlikView Server: Stores QlikView applications
3. QlikView Publisher: Loads data from sources and publishes it to the clients.

• QlikView – the data access solution that enables you to analyze and use information from different data sources.
• A number of features have been added to QlikView 10 with the purpose of providing possibilities to add metadata to the QlikView document. Adding metadata remains entirely optional for the developer.
• Fields can now be tagged with system defined and custom meta-tags. A number of system tags are automatically generated for the fields of a document when the script is executed.
• In analogy to field comments it is also possible to read or set comments in source tables. The comments are shown in the Tables page of the Document Properties dialog and as hover tooltips in the Table Viewer.
• Chart expressions can be given for an explanatory text comment. These are visible and editable in the Expressions page of the Chart Properties dialog,
• The script editor has been redesigned. A number of new commands can be found in the menus, e.g. the ODBC administrator can now be opened from inside the script editor; also the 32 bit ODBC administrator can be opened from a 64 bit QlikView
• The basic idea is that QlikView at script run spawns a second process – QVConnect – that in turn connects to the data source.  Two different QVConnect files are installed in the QlikView folder: QVConnect32.exe and QVConnect64.exe. It is also possible to develop custom connect programs.
• The interpretation and transformation of data are now done in multiple threads, which speeds up the load process tremendously. This does not imply any changes to the load script, i.e. the load script is still sequential: no parallel branches can be defined.
• In previous versions, Input Fields needed to be loaded in a well-defined order for their values to be correctly associated after a reload. The Input Field values were always associated with the same record number, which caused problems if the load order changed, for example by inserting new values.
• For more information visit Mindmajix