Discussion board where members can get started with QlikView.
Not entirely sure whether this can be done however my question is whether somehthing can be done more efficently and cleanly.
My script is as follows:-
From "qvd file A";
Outer Join (Stock)
From "qvd file B";
Quantity + Delivery - Dispatch as AvailableLevel
DROP Table Stock
Is there a cleaner means to achieving the same thing i.e. do away with having to load the table in from memory and then drop it?
Thanks in advance.
I don't think there's a quicker / neater way to achieve the same end result as the fields for the 'AvailableLevel' colculation only come together after the Outer Join.
If ther they were already together you could use a preceeding load to get to the end result:
Quantity+Delivery-Dispatch as AvailableLevel;
From "Ready Merged QVD File";
But I'm assuming that's not an option.
Apologies I couldn't be more assistance.
All the best,
Matt - Visual Analytics Ltd
Qlikview Design Blog: http://QVDesign.wordpress.com