Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I keep on getting the error Operation Aborted in QlikSense SaaS when I try to use an inner join with qvd file. Any ideas on how resolve this?
Qlik Cloud does have a hard limit on ram consumption. Could this be causing you this issue? Is your QVD file a very large qvd file or have you script been loading a lot of data into Memory in prior to your Join?
What does the setup look like? Intuitively I would think it is the inner that is the problem, but it depends on what your script actually looks like. Did you try an outer join instead?
how to check the qvd file size in QlikSense SaaS? Its sitting in some folder but I am unable to check size
I am using an inner join with the table on the primary key after I do a concatenate load with the initial qvd file. I am not sure whether an outer join would yield the correct results since I need only the records that match with the primary keys in the table
It becomes a problem if the table you are joining is already joined to your fact table. Because then you are not just joining on the primary key, but on all the field in the table you want to join.
But maybe that was not the issue? Do you load the entire table to be joined before the join statement?
I have decided to do a full reload of all the qvd's since my incremental load results were not matching up with the table counts. Thanks all for your help.