Overview

Up until now we were almost exclusively occupied with the loading of data. Starting with this lesson, we are mainly focusing on presenting and analyzing the data.

General settings

Activating the “Design-Toolbar” is one of the most important presettings for a QlikView designer. You can manage the visibility in the menu option “View”.

Screenshot 2015-03-28 15.11.28

Overview of the control objects

ListBox

The listbox helps finding, selecting and analyzing data within a certain area.

Screenshot 2015-03-28 18.26.45

The following colour code for visualization has been established by QlikTech:

Screenshot 2015-03-30 13.15.32

The background is white without selection.

Screenshot 2015-03-30 13.16.50

Once you choose a selection it turns grün, the remaining options stay white and non-choosable values turn gray.

By using the options “forward” and “backward” you can navigate within the selection history. By clicking reset, every filter gets removed.

MultiBox

The MultiBox is a space-saving alternative to the listbox. There is only one line per filter field.
Should only be used in “standard analyses” because it makes an association harder to sport.

Screenshot 2015-03-30 13.43.58

Slider/Calendar Object

The sliders or the calendar can be connected with numerical fields or variables.
Especially useful fo “from…to” analyses.

Screenshot 2015-03-30 13.51.29

Bookmark Object

With bookmarks you can save certain “data views”. Make use of this function, because different filters can lead to interesting discussions.

Screenshot 2015-03-30 14.19.18

Search Object

“Search Object” allows you to use one expression more than once in the same field. The results then show hits per “field”.

Screenshot 2015-03-30 14.21.57An overview of the data-presentation objects

Table Box

The TableBox – Table – is suited for performantly listing the datasets on the “lowest” level. Aggregations, formulas etc. are not possible. Use the chart-object as “table” to calculate and visualize simple or complex representations.

Chart

The Chart is the most complex type that you can use with QlikView. It allows pivoting, formatting, numerical and graphical representation of values.

Screenshot 2015-03-30 14.25.46

These types are:

  • Bar Chart – classic bar diagram
  • Line Chart
  • Bar-Line Chart – combination of the two previous diagram types
  • “Spider” – radar riagram
  • Tacho – speedometer
  • Mekko – relation adjusted quantitative data diagram
  • Scatter – single data points on a x-y scale
  • Bubbles – volume driven scatter diagram
  • Pie chart
  • Funnel diagram
  • Block Chart

The classic pivot and tables are the type:

  • Pivot Table
  • Straight Table

We are going to learn about each of the types later.

Exercises

  • Create an object of every type inside of an already filled QlikView document and breathe life into it.

Leave a Reply