topic Re: Preceeding load in QlikView

Preceeding load

markgraham123 — Mon, 22 Jun 2015 20:49:13 GMT

Hi,

I'm trying to do a preceeding load from two resident tables in the script.

"SKU, Quantity" in TableA,

"SKU, 360 dayvel." in Table B.

I wanna do the calculations:

If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8 as [0-8WOH]

Anyone can give me hints.

Re: Preceeding load

Tue, 23 Jun 2015 00:40:36 GMT

As per my understanding, the fields are on different table. If you want calculate on the script, please join the tables on a key & do the resident load. If two fields are in different table Precedent load won't work for ur case.

Please post full script to help further...

Re: Preceeding load

markgraham123 — Tue, 23 Jun 2015 01:22:54 GMT

Hi,

The script worked.

Thanq very much.

I wil post the full script from next time.

Re: Preceeding load

rwunderlich — Tue, 23 Jun 2015 01:26:57 GMT

As an alternative to Join, you can also use ApplyMap as a way to "reach across" to a field in another table.

Don't join - use Applymap instead