Text containing letter "T" is interpreted as numberArticle Number: 000044138 | Last Modified: 2019/01/24
This does not happen in QlikView 11.20 or earlier.
For example, the following expression: =Num(Timestamp#('14401019T000100','YYYYMMDDThhmmss')) returns the same numeric value -167,717.99930556 , which corresponds to the timestamp 1440/10/19 00:01:00.
In order to avoid this unexpected interpretation, a solution is to explicitly convert fields containing values like xxxxTyyyy into text using Text() function in the load script.
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.