topic Re: Pick last 4 values from another table 1 in QlikView

Pick last 4 values from another table 1

girish_talele — Fri, 26 Dec 2014 07:33:27 GMT

Dear Experts,

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. -

The P_Date of Prd Ord shall be equal or less than B_Date (i.e. Biling Date)
If say the Cumulative Sum of above production order qty (i.e. P_Qty) of last two Prd Ords is equals or higher than Billing Qty then no need to fetch more production orders.

Please suggest how to map the requirements.

At least 1'st requirement, which is important to us.

Regards,

Girish.

girish_talele — Sat, 03 Jan 2015 06:13:01 GMT

Dear Experts,

Is there any way out??

Sat, 03 Jan 2015 07:29:20 GMT

Inter table field comparison in the Where clause is achieved using the peek function for instance:

P_Date <= Peek('B_Date',0,'Billing')

Sat, 03 Jan 2015 07:32:32 GMT

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.