Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
load ....
sql select...........
where col=value;
Hi,
is there the ";" ?
LOAD [Invoice Number] Where ([Invoice Number] <> 0)
;
SQL SELECT..
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
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";
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;
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;
Awesome! Thanks Thomas and Sneha!
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 ;