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

Joins

Joins in QlikView are similar to joins in SQL. Joins between two tables always result in one table. With joins, the columns of the two tables are affected. Joins are explicitly made by using inner join, left join, right join, and outer join.

In QlikView, joins work in the following ways:

  • Inner join: Only the matching records in the two tables are stored.
  • Left join: All the records from the first/left table are kept, and only those records from the second table that match a record in the first table are kept.
  • Right join: All the records from the second/right table are kept, and only those records from the first table that match a record in the second table are kept.
  • Outer join or join: Records from both the tables will be stored and, where possible, ...

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