Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
James123__
Partner
Partner

DateTime issue. My results give Text and Numeric in same field? Can't convert to date, only int/num

Hi Everyone

When I import my date into qlik from a CSV, the field has the tag numeric only. It contains date time data.

I have tried converting in a few ways but I can see that qlik is seeing two different types of data. When I try convert to text, remove spaces and then split into the date format it shows two alignments on the field. So text and numeric?

Has this ever happened to anyone? The CSV is large and am struggling to open it anywhere outside of QlikSense at the moment.

I just want the date, 'DD/MM/YYYY'...

 

Issue.PNG

James

Labels (3)
3 Replies
santhiqlik
Creator
Creator

Hi,

Try using this in load script to convert to date..

Date(Date#(field name,'DD/MM/YYYY'))
James123__
Partner
Partner
Author

Thank you for responding.

I have tried that as well as even loading left(Date,4) as year, doing the same for month and year. For each part. Then loading in another table as makedate() using year, month and day. 

Still, I only get numeric fields which is why I am so stuck in this case. The origin of this data before it was a CSV extract was MySQL where it reflects as datetime.

 

 

James123__
Partner
Partner
Author

This is a zippedQVD Extract of the Date column that I am struggling to convert