As you know from the earlier chapters on accessing data, Qlik Sense makes associations between tables using similar field names. As of Qlik Sense Version 2.0, there is a data profiling tool that can be used to help you make the correct table associations.
TestData. For this example, we will use the C: drive:
Transactions: LOAD DATE(Date#( TransactionDate,'DD/MM/YYYY')) as TransactionDate ,Sales INLINE [ TransactionDate, Sales 01/01/2013, 1000 02/01/2013, 3000 03/01/2013, 500 04/01/2013, 4000 05/01/2013, 2000 ]; Calendar: ...