The power of Qlik Sense Associative resides in how your tables are associated. Unlike SQL tools, you don't have to worry about Many-To-One and One-To-Many relationships and predefine the exploration path between your data. You can load your data, set which fields (usually called key fields) are the links between the tables, and Qlik Sense Associative takes care of the rest.
Now, let's see how we can create the associations between the two tables we have loaded:
On the right-hand side of the screen, you can see a section called Recommended associations. While loading your data, Qlik Sense analyzed your tables and proposed how to associate your tables based on a complex algorithm that considers distinct values of each field, column names, and the frequency of each value for each table.
Press the Preview all button to check how Qlik Sense is proposing...