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.
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”.
Overview of the control objects
The listbox helps finding, selecting and analyzing data within a certain area.
The following colour code for visualization has been established by QlikTech:
The background is white without selection.
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.
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.
The sliders or the calendar can be connected with numerical fields or variables.
Especially useful fo “from…to” analyses.
With bookmarks you can save certain “data views”. Make use of this function, because different filters can lead to interesting discussions.
“Search Object” allows you to use one expression more than once in the same field. The results then show hits per “field”.
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.
The Chart is the most complex type that you can use with QlikView. It allows pivoting, formatting, numerical and graphical representation of values.
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.
- Create an object of every type inside of an already filled QlikView document and breathe life into it.