I am new to QLIK, but have worked my way through the basics. I have a problem joining QVD tables.
I have produced QVD tables that I want to use across other Apps, but the my current App I don't need all the data from Fact QVD table, I want to use other QVD by a join to only bring back data which is in both tables but also join it by field that I don't want to return in the report. Is this possible?
The fact file has 6m rows, when I do inner join it still fetches 6m rows first rather 1m rows I would expect with the join, I am guess it doesn't work like SQL. This causes a memory issue because I am using a basic laptop
It still brings back the same data but the memory issue is no longer an issue. Unfortunately, it works with 2 tables but when I need to add further to tables it uses the smaller table as the fact table.
if you are limited on memory, then doing the join in SQL could be your best alternative, another option is to before you do the join add a where exists condition to reduce the data and then apply a join to the resident table, you will have both tables in memory but the data that is loaded is already reduced.
I do not apply during the joins because I have noticed that QV first does the join and then applies the where clauses