Where clause

[#1]

Hi Everyone

I would like to exlude values from a table that I load from an sql database with a "Where" clause. I just do not seem to get the syntax right...

This is what I tried:

LOAD [Invoice Number]  Where ([Invoice Number] <> 0)

SQL SELECT..

Thank you very much for your help!

[#2]

load ....

sql select...........

where col=value;

[bbi_mba_76]

Hi,

is there the ";" ?

LOAD [Invoice Number]  Where ([Invoice Number] <> 0)

;

SQL SELECT..

[#4]

where should come after select coz ur getting only the that u need from the db. so try with my syntax... I can try for u if u share ur file

[#5]

This is my SELECT statement:

SQL SELECT

ardatum,

    Year (ardatum) as Jahr,

    Month (ardatum) as Monat,

    jobnr,

    netto,

    fw,

    prodnr,

   "Invoice Number",

    firma,

    kurs

FROM EASY."ar_kopf";

[#6]

SQL SELECT

ardatum,

    Year (ardatum) as Jahr,

    Month (ardatum) as Monat,

    jobnr,

    netto,

    fw,

    prodnr,

   "Invoice Number",

    firma,

    kurs

FROM EASY."ar_kopf" where [Invoice Number] != 0;

[#7]

load (all ur fields) SQL SELECT ardatum,     Year (ardatum) as Jahr,     Month (ardatum) as Monat,     jobnr,     netto,     fw,     prodnr,   "Invoice Number",     firma,     kurs FROM EASY."ar_kopf"; where [Invoice Number]=value;

[#8]

Awesome! Thanks Thomas and Sneha!

[#9]

What is the filter in the your Where Clause.

If you are writing the Where Clause in SQL SELECT statement, follow the SQL query format rules not Qlikview.

SQL SELECT

ardatum,

    Year (ardatum) as Jahr,

    Month (ardatum) as Monat,

    jobnr,

    netto,

    fw,

    prodnr,

   "Invoice Number" AS INVOICE_NUMBER,

    firma,

    kurs

FROM EASY."ar_kopf"

Where "Invoice Number" !=0 ;