Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Where statement

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!

1 Solution

Accepted Solutions

Re: Where statement

Hi Try below

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


OR


"auf_datum" < CURRENT_DATE();


Regards

ASHFAQ



10 Replies

Re: Where statement

Hi Which database you use

Regards

ASHFAQ

Re: Where statement

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

Not applicable

Re: Where statement

pervasive

Re: Where statement

Dear,

sara leslie

Again no points awarded in this thread.

Regards

ASHFAQ

Not applicable

Re: Where statement

this one did not work...

Re: Where statement

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

and is this date field or string?

Regards

ASHFAQ

Not applicable

Re: Where statement

Thank you for your help

the format is dd.mm.yyyy

Re: Where statement

Hi Try below

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


OR


"auf_datum" < CURRENT_DATE();


Regards

ASHFAQ



Not applicable

Re: Where statement

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

Community Browser