Lesson 10 – Standard data presentation

Overview In this lesson we will get to know some of the most common charts and how we can make them prettier. Bar graph With the help of bar graphs comparisons between individual groups of values ​​can be created quickly (quantitatively). In doing so, the orientation of the charts can create a clean representation even […]

Read More →
Lesson 9 – Basic pivot functions

 Overview In this lesson we are going to learn about the most important aggregation functions in detail and how to “modulate” them to our purpose. A short introduction into the set-analysis is going to show us one of the most powerful functionalities. Pivoting made easy To create a cross table right-click an “empty” area on […]

Read More →
Lesson 8 – Working on the User-Interface

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”. Overview […]

Read More →
Lesson 7 – Exercises

Overview In this lesson you are going to repeat all you learned on your own with your acquired skills and techniques. Task 1 – Dataloader Adventure Works Create a dataloader with a connetion to the acces file – AdventureWorksSample which can be found in “Admin/Common/Libs/QVComponents/Examples/DbExtract” Qualify the datas and save them into the DataStaging (work […]

Read More →
Lesson 6 – Script Tips ‘n’ Tricks

Overview This short lesson concentrates on typical questions from practice and their possible solutions. Marking of duplicates In practice it often happens that “duplicates” for one information exist but you only want to consider the “newest” dataset. To prevent this problem, QlikView offers so called “interrecord-functions” within scripts. These allow to access previous or following […]

Read More →
Lesson 5 – Project organisation

Overview This lesson handles the general organisation and structuring of QlikView projects. Based on our longtime experience with software development and QlikView implementations, we here show our “Best Practice”. As easement for our own projects we provided an online template which enables the development of stable BI-solutions following our standards. https://github.com/FrenzelGmbH/qlik Folder structure ADMIN COMMON […]

Read More →
Lesson 4 – Structuring scripts and using functions

Overview To not lose track in longer scripts, you have the possibility to structure the script. QlikView offers you to classify via index cards. Additionally we use easy functions to enrich our datamodel. Generate an index sheet To simplify the finding of ladelogics in the script, structure the script by creating new tabs or moving […]

Read More →
Lesson 3 – load and document data

Overview In this lesson we are going to learn the most important rules of importing data. This is just a recommendation, not a “must”! Documentation – comments Th emost efficient form of providing your logics and thoughts to your fellows is to wirte comments within your scripts. You can write these at any point in […]

Read More →
Lesson 2 – Basic script syntax

Overview In this lesson we are focusing on the most frequent script commands and their practical application. Basic structure syntax Some of the most frequently used commands are: CONNECT SELECT LOAD With which data in QlikView can be identified and loaded If you are uncertain exactly how a command is used, use the in QlikView […]

Read More →
Lesson 1 – Data sources and data structures

Overview This lesson deals with the import of data sources and the general understanding of data structures. Data sources In today’s world, there are a variety of possible sources of data to be loaded and merged. The most common formats are: SQL Databanks (MSSQL, MYSQL, Postgres SQL, …) NOSQL Datenbanks (CouchDB, ElasticSearch, NoSQL, …) REST […]

Read More →