topic Re: Syntax question(must be simple answer) in QlikView

Syntax question(must be simple answer)

timsaddler — Fri, 23 Nov 2012 13:50:18 GMT

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

;

Re: Syntax question(must be simple answer)

swuehl — Fri, 23 Nov 2012 13:53:15 GMT

Try

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

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

Re: Syntax question(must be simple answer)

timsaddler — Fri, 23 Nov 2012 14:07:37 GMT

thanks - newbie with qv syntax - helped me a lot

Re: Syntax question(must be simple answer)

timsaddler — Fri, 23 Nov 2012 14:07:43 GMT

thanks - newbie with qv syntax - helped me a lot

Re: Syntax question(must be simple answer)

timsaddler — Fri, 23 Nov 2012 14:08:28 GMT

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