Discussion Board for collaboration on QlikView Scripting.
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.
do you mean apply a join and then get this calculation ?
from your table
from your table two;
drop table one;
Sum([Qty On Hand]) as [Total Quantity]
GROUP BY SKU#;
LOAD SKU#, [Qty On Hand]
If(([Total Quantity]/([360-day Velocity]/52))>=0 and ([Total Quantity]/([360-day Velocity]/52))<=8, [360 0-8 WOH])
DROP Table Table16;
Lemme knw whether this is fine?
yes, that should work, assuming that join between table 16 and table 17 is correct
please post some sample data and your exprected result.