topic Re: Where statement in QlikView

Where statement

Wed, 25 Jun 2014 14:13:15 GMT

Hello experts

I would like to exclude values in a field that are in the future using a where statement:

SQL SELECT "auf_datum",

bez as Leistungstext,

jobnr,

"auf_anzahl",

ltyp,

storniert,

optional,

verkauf_soll as VK_soll,

verkauf_ist as VK_ist,

einkauf_ist as EK_ist,

auf_brutto as EK_soll,

jznr,

lartnr

FROM EASY.jleistg where storniert = 0 and optional = 0 and "auf_datum" < (here I would like to load the actual date);

Does anyone know how to read the date in there?

Thank you for your help!

Re: Where statement

ashfaq_haseeb — Wed, 25 Jun 2014 14:17:36 GMT

Hi Which database you use

Regards

ASHFAQ

Re: Where statement

ashfaq_haseeb — Wed, 25 Jun 2014 14:20:24 GMT

try Below

SQL SELECT "auf_datum",

bez as Leistungstext,

jobnr,

"auf_anzahl",

ltyp,

storniert,

optional,

verkauf_soll as VK_soll,

verkauf_ist as VK_ist,

einkauf_ist as EK_ist,

auf_brutto as EK_soll,

jznr,

lartnr

FROM EASY.jleistg where storniert = 0 and optional = 0 and "auf_datum" < DATE(CURDATE())

Regards

ASHFAQ

Re: Where statement

Wed, 25 Jun 2014 14:21:30 GMT

pervasive

Re: Where statement

ashfaq_haseeb — Wed, 25 Jun 2014 14:22:13 GMT

Dear,

sara leslie

Again no points awarded in this thread.

Regards

ASHFAQ

Re: Where statement

Wed, 25 Jun 2014 14:23:18 GMT

this one did not work...

Re: Where statement

ashfaq_haseeb — Wed, 25 Jun 2014 14:28:54 GMT

Hi can you tell me in which format you have dates?

and is this date field or string?

Regards

ASHFAQ

Re: Where statement

Wed, 25 Jun 2014 14:31:24 GMT

Thank you for your help

the format is dd.mm.yyyy

Re: Where statement

ashfaq_haseeb — Wed, 25 Jun 2014 14:35:56 GMT

Hi Try below

"auf_datum" < replace(cast(curdate() as char(10)), '-', '.');

"auf_datum" < CURRENT_DATE();

Regards

ASHFAQ

Re: Where statement

Wed, 25 Jun 2014 14:37:20 GMT

Hi!

Never used such database, but you can use qlikview for this purpose:

load *

where storniert = 0 and optional = 0 and auf_datum < DATE(today())

;

SQL SELECT "auf_datum",

bez as Leistungstext,

jobnr,

"auf_anzahl",

ltyp,

storniert,

optional,

verkauf_soll as VK_soll,

verkauf_ist as VK_ist,

einkauf_ist as EK_ist,

auf_brutto as EK_soll,

jznr,

lartnr

FROM EASY.jleistg

Re: Where statement

Wed, 25 Jun 2014 14:43:01 GMT

Second one works for me. Thank you very much!