What is QlikView

The most flexible reporting and analysis tool for turning data into knowledge.

QlikView is a general tool for interactive compilation, dynamic analysis and presentation of data extracted from one or many data sources. QlikView creates endless possibilities of making ad hoc queries in a non-hierarchical data structure. This is made possible by AQL - (Associative Query Logic) - for automatically associating values in the internal QlikView database.

Effective decision-making is based on having the right information available and easy accessible. Due to the problematic process of turning data into knowledge, most organisations today find themselves being "data-rich" but "information-poor".
The automatic associations of QlikView create endless possibilities for making ad hoc queries without requiring tediously defined structures and hierarchies, as is typical in other data analysis tools. QlikView promotes unrestricted analysis of application data, helping users make time-saving and accurate decisions.
QlikView is very easy to implement and use. It can be installed in a productive environment in days (not months) and users are trained in a couple of hours (not days). The cost benefits that it offers are therefore significant.

Key Features

QlikView - What is AQL?

Traditional OLAP technology was good enough at the time it was developed, but it has some major disadvantages. OLAP-based Hypercubes limit users to a small number of dimensions. Measures have to be defined when the application is developed and redefinition of a measure is time-consuming. The user interface is complicated for non-IT people to understand. Bottom line is that OLAP-based Hypercubes and Data Warehouses are expensive and time-consuming solutions to install.

QlikTech's patented AQL (Associative Query Logic) technology works in a different way, by building and maintaining a non-relational, associative and highly space efficient database that resides in RAM. The advantage of the AQL architecture is that the source data is retained and immediately available offline for analysis, all the way down to the source transactions. The result is powerful analytical capabilities provided through a highly intuitive user interface that encourages exploration and creativity.

Integration of many different data sources

QlikView supports many different business areas and is a perfect tool for integrating various data sources. It is also well suited for bridging the gap between old and new systems. The important thing for QlikView is the data, not the system storing it.
In a single, SQL-like script, QlikView lets you integrate data from OLEDB, ODBC, Excel files, text files, AS/400, HTML and XML. The program will also let you export data in a number of formats as well as serve as a data source for other programs.