QlikView

Performance Tuning

After implementing a data model with vast amount of data, the demand to optimize the data model rises in order to fulfill following requirements:

  • Increase response time per selection
  • Faster application reload / opening and script runtime
  • Hard drive size (footprint)

Read More…

Creating simple dynamic Data Quality Sheets

Once loading data into the QlikView script/application, data validation becomes one of the first tasks to accomplish. Here, I have provided a simple was in order to build a data validation sheet in order to analyze data by selecting table and field. The ability to obtain statistics for the field and values, make it easier in order to perform simple data quality checks.
Read More…

TrueChart Extension Review

TrueChart is an extension both for Qlik Sense and QlikView. It is an instrument to display visualizations according to International Business Communication Standards (IBCS). By this, a common understanding and displaying language can be achieved for QlikView and Qlik Sense applications within the organization. The unified given structures and rules make it convenient to concentrate on the data quality and information/message to be told rather than on the displaying aspects. The centrally controlled dynamic commenting function wraps the whole extension.
Read More…

Implementing simple KPI Visualisations

A dashboard or cockpit should clearly communicate key information to users. It should be kept simple and therefore and effective design is crucial. Besides showing the current situation, it should also show comparisons and trends.
Read More…