Using JOIN and deleteing records

Mon, 18 Aug 2014 14:06:04 GMT

Hello All,

I'm new to Qlikview, hope someone can help.

I am trying to (1) load a lookup table for SKU# and Category (2) load Actual/Plan/Last Year data by SKU$, MonthID & P&L line (3) load Forecast data by SKU$, MonthID & P&L Line.

In (3) above there are certain records I want to delete for a specific Category.

I JOIN (2) and (3) then JOIN (1) as a temporary table. From this temp table, in the the Category dimension I want to delete all records for item 'FS Export' . Finally I want to drop the temp table.

I get an error on the 2nd join, not sure how to do this. Please Help !!

Material_Info

LOAD SKU#,
Category, // there are lots of other fields for this table but removed them here to keep it simple
FROM

(biff, embedded labels, table is [MAT_INFO$]);

Main_Data:
LOAD MonthID,
[Material #],

    Measure,
     [2014 Actual],
     [2014 Plan],
     [2013 Actual]
FROM
Data_For_Actuals.xlsm
(ooxml, embedded labels);

OUTER JOIN (Main_Data)
Forecast_Data:
LOAD MonthID,
     [Material #],
     [Measure],
     [Forecast_Amount]
FROM

(ooxml, embedded labels, table is New_Data);

OUTER JOIN (Main_Data)
Temp:
LOAD *,Category
Resident Material_Info
Where Category <> 'FS Export';
DROP TABLE Temp;

Thanks.

topic Using JOIN and deleteing records in QlikView

Using JOIN and deleteing records