Script Question: Use item in a load statement within a formula in another load statement

Thu, 08 Dec 2011 16:04:55 GMT

I have researched my question and have been unable to find an answer.

Here is my issue: I have two loads statements. The first load statement contains fields from a product (dimensional) table. This load statement includes a fields titled ITEM and a field titled STATFACTOR. The second load statement contains shipment quantity information by item (and other key fields). This load also contains a field titled ITEM. I would like to take the STATFACTOR field from load one and add it into load two so that I can use it in a calculation within that load.

My Question: Is it possible to take a field from one load statement and add it into another load statement, and then use that field within a formula within the second load statement? If so, can examples be provided?

Any assistance is much appreciated.

Thank you,

Godfrey

Script Question: Use item in a load statement within a formula in another load statement

swuehl — Thu, 08 Dec 2011 16:31:27 GMT

You can probably use a mapping table to achieve what you want, like

Table1:

MAPPING LOAD

ITEM,

STATFACTOR

from ...;

Data:

LOAD

FIELD1,

FIELD2,

ITEM,

...,

VALUEFIELD * applymap('Table1',ITEM), 'OnTime', 'Late') as YOURCALCULATIONUSINGMAP

from ...;

topic Script Question: Use item in a load statement within a formula in another load statement in QlikView

Script Question: Use item in a load statement within a formula in another load statement

Script Question: Use item in a load statement within a formula in another load statement