Prepare a new qlik project

Intro

If you prepare yourself for a „seeing is believing“ workshop or going to start a new qlik project. Be aware that you should prepare your work environment!

 System Requirements

Based upon the size of your data and the number of clients you need to „size“ your server or developer workstation.

For a minimum developer workstation you should at least have:

  •  500GB HardDrive (2 Partitions 100,400)
  • >= i5 (min 2CPU)
  • 8 GB RAM

For a minimum server you should at least have:

  • 500GB HardDrive (2 Partitions 100,400)
  • >= 4 CPU (current tech)
  • 16 GB RAM

If you wonder why the server needs „more“ ressources, it’s because each user will generate a little overhead working on the server!

 Data Access

Depending on the customers data sources and to download little helpers, it’s helpful to have:

  • Access to the internet
  • File Access to all „text“ based data sources
  • ODBC or OLEDB READ Account (we recommend to name it QVREADER)

Data Structure

People who work with the data and can deliver as much data structure knowledge as possible.

Data „Digging“

After you have access to the datasources, build an quick and „dirty“ qvd datastaging layer. We normally suggest to do this in our qlik project template – so work is usable for production later. Take a look at the data loading „FIRST 10000“ records from each datasourse and build a quick star schema.

Whale and Dolphin Watch – La Gomera

Where to go?

If you ever had the wish to watch whales and dolphins in real „free“ live, than one of the many places to go can be La Gomera, one of the tiny islands in the canary group.

Screenshot 2015-04-14 09.42.08

Depending on the time of the year, you can see different whales and/or dolphins. One of the „whale watching“ companies has a detailed log about what has been seen and when (http://oceanogomera.blogspot.de/)! I wrote an tiny qlikview app, which can be downloaded here, so you can make yourself a quick impression:)

 What you can see?

  • Pilotwale – Pilot whales – Calderones tropicales – Globicéphales
  • Fleckendelfine – Atlantic Spotted Dolphins – Delfines moteados – Dauphins tachetés de l’Atlantique
  • Brydewal – Bryde’s whale – Rorcual tropical- Rorqual tropical
  • Grosse Tümmler – Bottlenose dolphins – Delfines mulares – Grands dauphins
  • Gewöhnliche Delfine – Common Dolphins – Delfines comunes – Dauphins communs

What we have seen!

We went out by boat 4 times during our one week stay! 😉 We choose YANI – http://www.excursionesyani.es/index.php/en – as they had a glass bottom boat and was kind of big and same time small enough to ride with! The whole team was super friendly and tried to answer our questions as good as possible!

Here is what we saw:

 

QlikView – Color Blend by Dimension Value

Overview

Sometimes you wanna define a „color schema“ by the values of a dimension. The easiest way is to generate a mapping table where each dimensionvalue gets an color assigned.

Downloads

First load the color table as CSV from here and save them into the same folder where you wanna create and run the QlikView Worksheet:

 Sample

If you wanna update the colors „online“ just replace the first load with:
After this we create a bar chart with the YourFieldname as Dimension and 1 as Formula:

Screenshot 2015-04-02 12.55.30

To color it as we wanted to, we will edit the background formula for the formula as here:

Screenshot 2015-04-02 14.26.18Which leads us to the following result:

Screenshot 2015-04-02 14.27.15