topic Re: Where clause in QlikView

Where clause

Thu, 05 Jun 2014 11:33:40 GMT

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!

Re: Where clause

Thu, 05 Jun 2014 11:35:05 GMT

load ....

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

where col=value;

Re: Where clause

bbi_mba_76 — Thu, 05 Jun 2014 11:38:04 GMT

Hi,

is there the ";" ?

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

;

SQL SELECT..

Re: Where clause

Thu, 05 Jun 2014 11:41:17 GMT

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

Re: Where clause

Thu, 05 Jun 2014 11:45:31 GMT

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";

Re: Where clause

Thu, 05 Jun 2014 11:47:34 GMT

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;

Re: Re: Where clause

Thu, 05 Jun 2014 11:48:14 GMT

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;

Re: Where clause

Thu, 05 Jun 2014 11:55:11 GMT

Awesome! Thanks Thomas and Sneha!

Re: Where clause

Thu, 05 Jun 2014 11:57:27 GMT

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 ;