Hi,
I have several csv. files for different years. When I associate the sale.order 2018 and sale.orderlines 2018 the sales is 16102 units
but when I add the sale.order 2019 and sale.ordelines 2019 as well, which qlik automatically concatenates them because they have the same fields names, the value for 2018's sale will increase to 17678 units. I have read that concatination in qlik will only join the tables together, but in my case, most probably during concatination some extra rows of data is created. Do you have any suggestion, how can I get the accurate sale number?