Tag Archives: join

Most popular posts of 2012 & plans for 2013

QlikFix: Best of 2012It’s that time of the year again where we take a look back at the past year and make plans for the new year. I hope you can look back at a successful year and have many exciting plans for the future.

For me, it’s been an intense but very fulfilling year, culminating in the release of the QlikView 11 for Developers book. I look forward to a new year filled with great opportunities and developments.

The QlikFix blog has been doing very well in the past year. 2012 brought roughly 50% more traffic than 2011 and the trend is moving upward. In this post I will share with you this year’s top 5 best read articles, and also request your input in shaping my plans for the blog in 2013.

read more »

Merging tables: the JOIN prefix

Merging tables: the JOIN prefixThis is the second post in a series on merging tables in QlikView. In the previous post I wrote about appending rows to tables by using the CONCATENATE prefix, this time I will show you how to add  columns to a previously loaded table by using the JOIN prefix. 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 »