topic Re: Date field in Qlik Sense not supporting when extraction from SAP BW in Connectivity & Data Prep

Date field in Qlik Sense not supporting when extraction from SAP BW

Arindam_Ghoshal_13 — Mon, 30 May 2022 17:38:02 GMT

Re: Date field in Qlik Sense not supporting when extraction from SAP BW

vamsee — Thu, 26 May 2022 20:16:05 GMT

Hi,

Have you tried re-formatting the date field while loading the data?

Try

Date(Date#(CREATEDON, 'MM.DD.YYYY')) as CREATEDON

Also try

Num(Date#(CREATEDON, 'MM.DD.YYYY'))

and see if you are getting a number value for the dates

Re: Date field in Qlik Sense not supporting when extraction from SAP BW

vamsee — Fri, 27 May 2022 20:22:04 GMT

Can you share the data with just two columns Rowno and Date field without any formatting, something like

Source: Load RowNo() as RowId, DateField; SQL * From Source; Store Source into Source.qvd (qvd);

Re: Date field in Qlik Sense not supporting when extraction from SAP BW

vamsee — Fri, 27 May 2022 23:44:27 GMT

Was just checking my SAP source and noticed that DATS field is always in YYYYYMMDD format.

Try that just in case

Date(Date#(CREATEDON, 'YYYYMMDD')) as CREATEDON

Re: Date field in Qlik Sense not supporting when extraction from SAP BW

Arindam_Ghoshal_13 — Wed, 01 Jun 2022 07:14:01 GMT

Hi @vamsee ,

The Material codes were having Duplicate values

00000MatCode --having Date values
MatCode -- Not having Date values

I was searching Matcodes(40*) as I assumed inital 0s were eliminated by Qlik.

Thanks for the reponse.