Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
fahmin
Contributor
Contributor

Change data type of field incorrectly identified as date

Hi,

I have loaded data from a field with values such as '01-01-01',  and it is actually a string used to identify categories. Qlik has incorrectly loaded this field as a date.

Is there a way to load this field as a string?

Many thanks,

Fahmin

Labels (2)
1 Solution

Accepted Solutions
Prashant_Naik
Partner
Partner

Hi,

You can try this, By putting

text(date field) as datefield might help you.

Regards,

Prashant

View solution in original post

2 Replies
Prashant_Naik
Partner
Partner

Hi,

You can try this, By putting

text(date field) as datefield might help you.

Regards,

Prashant

View solution in original post

fahmin
Contributor
Contributor
Author

Thank you so much!