Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using JOIN and deleteing records

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.

0 Replies