We learned in the preceding section about joins and their use cases. When it comes to using joins in Qlik Sense, it has been seen that a join on larger tables slows down the data loading and, if not used properly, may consume higher resources. Also, we have seen the pitfalls of using joins, as they tend to increase the number of records.

When you want to perform the join to get a single field value, the best way is to use an alternative method: Applymap().