topic Cut the SAP table VBRK by dates in QlikView

Cut the SAP table VBRK by dates

Tue, 21 Sep 2010 09:04:49 GMT

Hello,

I'm trying to cut the SAP table VBRK by dates.

I would like to download data from the table when the fields ERDAT and AEDAT = yesterday.

I tried "Makedate" function and other functions without success.

Does anyone have experience on?

Thank you

Elad

Cut the SAP table VBRK by dates

suniljain — Tue, 21 Sep 2010 10:50:00 GMT

declare one variable name is yedterday

and assign date that is today()-1,

and pls use that variable in where condition like

where erdat = Yesterday and AEDAT = Yesterday

Cut the SAP table VBRK by dates

Tue, 21 Sep 2010 11:06:54 GMT

Hello Sunil,

Thank for your answer,

The problem that is QV not difined the EADAT filed as a date field.

Elad

Cut the SAP table VBRK by dates

cotiso_hanganu — Wed, 22 Sep 2010 15:25:36 GMT

than use NUM() function to make it a number

Cut the SAP table VBRK by dates

cotiso_hanganu — Wed, 22 Sep 2010 15:25:54 GMT

Most likely you are trying to use makedate function (which is a QlikView function, available only in LOAD statements) in a SQL SELECT statement which should use the respective SQL syntax.
More advice if you show us some script sample.

Cut the SAP table VBRK by dates

suniljain — Thu, 23 Sep 2010 08:24:51 GMT

right now I am unable to log in SAP so can you tell me it is in which format.