Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
timsaddler
Creator III
Creator III

Syntax question(must be simple answer)

Hi - i need to remove several business units from the data when loading

However script isn't working

 

 

FACT:

LOAD Date(TR_Date) as TRDate,
    "Item_Number",
    "Item_Desc",
    "Business_Unit",
    Quantity,
    "Doc_Type",
    UOM,
    "Usage_Var",
    "Theoretical_Usage",
    Adjustments,
    (Usage_Var + Theoretical_Usage + Adjustments) as Actual_Usage
    Where Business_Unit <> '1832105' or '1611102'
  
   
      
    ;
SQL SELECT *
FROM "OPI_DATAMART".dbo."F_DATA_Asphalt_Usage_RCI"

What have i done wrong !!!

thx in advance

;

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

Where Business_Unit <> '1832105' and Business_Unit <> '1611102';

or

where not match(Business_Unit, '1832105','1611102');

View solution in original post

4 Replies
swuehl
MVP
MVP

Try

Where Business_Unit <> '1832105' and Business_Unit <> '1611102';

or

where not match(Business_Unit, '1832105','1611102');

View solution in original post

timsaddler
Creator III
Creator III
Author

thanks - newbie with qv syntax - helped me a lot

timsaddler
Creator III
Creator III
Author

thanks - newbie with qv syntax - helped me a lot

timsaddler
Creator III
Creator III
Author

thx - that helped a lot - i'm a newbie with QV syntax