# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Contributor II

## preceeding load from two tables

Hi,

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

"Quantity"  in TableA,

"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 (2)
4 Replies
Valued Contributor III

## Re: preceeding load from two tables

do you mean apply a join and then get this calculation ?

something like

one:

fields

join

fields

*,

calculations

resident one;

drop table one;

Contributor II

## Re: preceeding load from two tables

Table17:

Sum([Qty On Hand]) as [Total Quantity]

GROUP BY SKU#;

Resident SKORT;

Join(Table17)

Resident Table16;

Table18:

If(([Total Quantity]/([360-day Velocity]/52))>=0 and ([Total Quantity]/([360-day Velocity]/52))<=8, [360 0-8 WOH])

Resident Table17;

DROP Table Table16;

Lemme knw whether this is fine?

Valued Contributor III

## Re: preceeding load from two tables

yes, that should work, assuming that join between table 16 and table 17 is correct

MVP