Discussion Board for collaboration related to QlikView App Development.
I am trying to use left join in qlik view like given below
From abc.qvd (qvd); //it have 85000 records
left Join (Trades)
From xyz.qvd (qvd); //it has 3,00,000 records which has all the records from abc.qvd
Store Trades into final.qvd;
When I put Trades table in table object on qvw UI it gives me expected result that is all the records from abc.qvd along with new field i.e. z from xyz.qvd and total record count is 85000
but when I load all the records from final.qvd in another qvw I am getting some weired number of records which are not equal to 85000 or 3,00,000
why is this happening ??
If the values of the associated field (a) are not unique in xyz.qvd, then that will cause rows to be replicated when joining. The left join means that only the records that have an existing a value (from abc.qvd) will be loaded.
So if you have non-unique values of a in xyz.qvd, you can expect to get a final result of at least less than 85k rows and not more than 3 084 999 rows.
Thanks for quick response @jonathandienst
But that still does not explain why I am seeing different number of records when I put same table in table object on sheet/UI vs when I store it in another qvd i.e. final.qvd.
It should have same number of records in both cases right? correct me if I am wrong.
Is there any tables with the same columns in final.qvd table?
I think your final table has auto-concatenated with another table in your final qvw.
To avoid this, try:
Just wanted to give you a Design Blog post on what Arthur mentioned that may be of some help: