The JOIN statement

The JOIN statement is a prefix to the LOAD statement. It is used to join the table that is being loaded to a previously loaded table. The two tables are joined using a natural join, this means that the columns in both tables are compared and the join is made over those columns that have the same column names. This means that if multiple columns are shared between tables, the match will be made over the distinct combinations of those columns.
By default, QlikView performs an outer join. This means that the rows for both tables are included in the resulting table. When rows do not have a corresponding row in the other table, the missing columns are assigned null values.

An Equal Sign: different controls and how they treat a dollar expansion

Source

Some functions

• PurgeChar
• WildMatch
• Dimensionality
• SecondaryDimensionality
• AGGR
• GetPossibleCount
• GetSelectedCount
• Concat
• IF
• $()
• TOTAL
• Alt

How to construct relative paths in QlikView

UI file:
[Z:\QlikView\SourceDocuments\Clients\QVW\Me\WIP\UI.qvw]

Source file:
[Z:\QlikView\SourceDocuments\Clients\Data\Messages.xlsx]                   

1. Common folder is [Clients]
2. To get there from UI file (in WIP folder) we have to go three folders up (Me -> QVW -> Clients)
3. So we add three placeholders [..\] & the path from the common folder: [..\..\..\Data\Messages.xlsx]