topic Load from SAP: where clause on date selection in QlikView

Load from SAP: where clause on date selection

Tue, 20 Nov 2012 09:24:19 GMT

Hello gurus!

I have an easy question which is driving me crazy!

The purpose is to load table AUFM from SAP. The field BUDAT is a date in following notation: 20/11/2012.

I want to load only the records from 2011 & 2012, therefore I use a where clause, but no records are loaded.

What is wrong in the script:

[AUFM]:

Load
   [MEINS] as [Base Unit_MEINS],
   text([MATNR]) as [Material_MATNR],
   [SHKZG] as [Debit/Credit_SHKZG],
   [WERKS] as [Plant_WERKS],
   [AUFNR] as [Order_AUFNR],
   [MENGE] as [Quantity_MENGE],
   [BUDAT] as [Posting Date_BUDAT],
   [BWART] as [Movement Type_BWART];
SQL Select MEINS MATNR SHKZG AUFNR WERKS MENGE BUDAT BWART from AUFM
where BUDAT > '31/12/2010'
;

Thank you for your help!

Re: Load from SAP: where clause on date selection

Anonymous — Tue, 20 Nov 2012 10:05:39 GMT

Hi Toby,

Make sure that your DateFormat in your Qlikview script matches the format of your Date field.

So in your cause I guess it should be:

SET DateFormat='D/M/YYYY';

SET DateFormat='DD/MM/YYYY';

Give it a try.

Good Luck,

Dennis.

Re: Load from SAP: where clause on date selection

Thu, 22 Nov 2012 14:11:12 GMT

Hello Dennis!

Thank you for your help, this did the trick.