O'Reilly logo

QlikView Essentials by Chandraish Sinha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Concatenation

Another way to optimize your data model in QlikView is through concatenation.

Concatenation is a way to combine or merge tables. It is similar to Union All in SQL. It appends rows from one table to another. The result of concatenation between two tables (Table1 and Table2, for example) is that a new table contains the sum of the numbers of records in Table1 and Table2. Concatenate is used when you have two fact tables in your data model. Two fact tables are not good for your data model. You can combine them using concatenate or link tables. Link tables are explained in the next chapter.

Concatenate is also useful when you have to combine two tables with similar structures. Say, for example, your organization has an Employee table that ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required