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… Read More

Continue Reading

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. 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 (! 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… Read More

Continue Reading

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: To color it as we wanted to, we will edit the background formula for the formula as here: Which leads us… Read More

Continue Reading