Dates From SAP BW

Sat, 13 Apr 2013 09:02:40 GMT

I get data into Excel from SAP BW and I have a problem with the dates in Qlikview. Date is output as MM.YYYY e.g 10.2012 or 4.2013. When i load my files into Qlikview it doesn't recognise these as dates and sorts them incorrectly like this

1.2012

1.2013

2.2012

2.2013

etc etc

I have looked at various posts without success. If someone could explain exactly what code I need and exactly where I should put it in the script. Do I also have to do anything in my listbox etc I would be extremely grateful

Thanks

Derek

Re: Dates From SAP BW

Sun, 14 Apr 2013 05:38:25 GMT

Hi Melvild1,

The dates are text and certainly qlikview doesn't recognize as date. In your script, you should include the date#() function (converts text to date) on your field, for example:

LOAD

...

Date(Date#(FieldDateAsText, 'M.YYYY')) as FieldDate

...

FROM ...

Where FieldDateAsText, is the field that contents date as text.

Regards,

Ricardo

topic Re: Dates From SAP BW in QlikView

Dates From SAP BW

Re: Dates From SAP BW