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.
