Discussion Board for collaboration related to QlikView App Development.
Hi - i need to remove several business units from the data when loading
However script isn't working
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 ;
Where Business_Unit <> '1832105' and Business_Unit <> '1611102';
where not match(Business_Unit, '1832105','1611102');
View solution in original post
thanks - newbie with qv syntax - helped me a lot
thx - that helped a lot - i'm a newbie with QV syntax