Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

markgraham123
Contributor II

Preceeding load

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.

Tags (1)
3 Replies
Not applicable

Re: Preceeding load

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

markgraham123
Contributor II

Re: Preceeding load

Hi,

The script worked.

Thanq very much.

I wil post the full script from next time.

Re: Preceeding load

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

Community Browser