Discussion board where members can get started with QlikView.
This is in extension to my earlier query (http://community.qlik.com/message/679411#679411)
In earlier query, requirement was to fetch last 4 production orders where the Prd ord link was missing. File is attached herewith.
Now we want to add two conditions while fetching LAST 4 production orders i.e. -
Please suggest how to map the requirements.
At least 1'st requirement, which is important to us.
Is there any way out??
Inter table field comparison in the Where clause is achieved using the peek function for instance:
P_Date <= Peek('B_Date',0,'Billing')
from the Qview Help
Load A, B, numsum( B, peek( 'Bsum' ) ) as Bsum...; creates an accumulation of B in Bsum.
maybe a helpful hint for the 2nd. requirement.