topic preceeding load from two tables in QlikView

preceeding load from two tables

markgraham123 — Mon, 22 Jun 2015 20:18:21 GMT

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.

Re: preceeding load from two tables

ramoncova06 — Mon, 22 Jun 2015 21:05:51 GMT

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

something like

one:

load

fields

from your table

join

load

fields

from your table two;

load

calculations

resident one;

drop table one;

Re: preceeding load from two tables

markgraham123 — Mon, 22 Jun 2015 21:16:38 GMT

Table17:

LOAD SKU#,

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

GROUP BY SKU#;

LOAD SKU#, [Qty On Hand]

Resident SKORT;

Join(Table17)

LOAD *

Resident Table16;

Table18:

LOAD *,

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?

Re: preceeding load from two tables

ramoncova06 — Mon, 22 Jun 2015 21:23:37 GMT

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

Re: preceeding load from two tables

MarcoWedel — Mon, 22 Jun 2015 21:51:56 GMT

please post some sample data and your exprected result.

thanks

regards

Marco