Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Arindam_Ghoshal_13
Contributor III
Contributor III

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

 
1 Solution

Accepted Solutions
Arindam_Ghoshal_13
Contributor III
Contributor III
Author

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.

View solution in original post

4 Replies
vamsee
Specialist
Specialist

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

 

vamsee
Specialist
Specialist

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);

 

vamsee
Specialist
Specialist

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
Arindam_Ghoshal_13
Contributor III
Contributor III
Author

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.