Monthly Archives: December 2010

Creating a custom sort order: load order & dual

Dual or Duel? Couldn't find a fitting picture to visualize the concept of sorting, so I decided to make a lame joke instead ;) Excellent movie though, really had me on the edge of my seat the entire time.In a previous post I described how to create a custom sort order in QlikView by assigning a sort order value in the load script or by using the match function. This post describes two other clever methods that I recently became aware of:

Read on to see how these methods work.

read more »

QlikView blog round-up: Selling QlikView (and shares)

Selling QlikView (and shares)This weeks QlikView blog round-up is all about selling, selling software and shares that is.

read more »

Consistent Dimension Colors

Consistent colorsA short tip today on how to ensure that dimensions in different charts get assigned the same color, regardless of how the data is sorted or if dimensions are missing.

The image on the right shows an example in which revenue per beverage is visualized in a number of different charts and tables. Each beverage is assigned its trademark color (Coca-Cola Red, Heineken Green, Pepsi Blue etc.)  and this color is used consistently in each of the charts. Read on to see how you can accomplish this effect.

(Please note that using lots of very bright/saturated colors in your dashboard or report is generally not a good idea, I am only using these colors because they are recognizable to many. Do not try this at work!)

read more »

QlikView blog round-up: Intellectual Curiosity & QVExcel

QVExcelAs I’ve been seeing many interesting QlikView articles and blog posts appear recently, I’ve decided to make the Blog Round-up a (bi-)weekly item on this blog. This week, there were two articles that caught my interest:

read more »

Merging tables: concatenation

Merging tables using the concatenate and join prefixesOne of the subjects I often see new QlikView developers struggle with, especially those without prior database experience, is merging data from different tables. In this series of two posts I will explain how to use the CONCATENATE and JOIN prefixes to bring together data from multiple tables.

Simply put, the CONCATENATE prefix lets you add rows to a previously loaded table, while the JOIN prefix lets you add columns to a previously loaded table.

Read on for the first post, which covers the concatenation of tables in more detail. read more »

QlikView blog round-up

Busy weekIt’s been a busy week with not much time to write, so instead of a fresh tip I bring you the QlikView articles and blog posts that I found most interesting this week:

read more »