Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New 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
Highlighted
Partner
Partner

Re: Change data type of field incorrectly identified as date

Hi,

You can try this, By putting

text(date field) as datefield might help you.

Regards,

Prashant

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Change data type of field incorrectly identified as date

Hi,

You can try this, By putting

text(date field) as datefield might help you.

Regards,

Prashant

View solution in original post

Highlighted
New Contributor

Re: Change data type of field incorrectly identified as date

Thank you so much!