I am new in Qlikview and am having a problem joining 12 tables together which are cumulative tables consisting of 12 monthly loads of data.
The structure of the tables are the same except for the contents which means that the tables are growing each month.
For example January has got 500 records with recordings in 25 sales units, February has got 550 records with recordings over 27 units etc. I would like to perform a right join over the 12 tables. So all the 550 records of February will be joined with the 500 records of January and so on. What I have encountered is that after the second join the results are unexpected.
How many tables can be joined in one query and any ideas on how to solve the problem as described above?
