topic Re: Auto-converting string type data to date type data in QlikView

Auto-converting string type data to date type data

sammykim_0624 — Sat, 16 Nov 2024 21:04:54 GMT

Hello community!

Lately, I was trying to load the string type date data from my work DB.

But it was so hard because qlikview converts this data to unix-time data for itself.

After all, I succeed this work converting the string type data to that I wanted to data,

but now I'm curious what happened in qlikview process that converts the data type.

Could anyone explain why this auto-converting happen and how can I handling this auto-converting with any setting in qlikview for me, please?

Re: Auto-converting string type data to date type data

fosuzuki — Thu, 11 Apr 2019 00:55:45 GMT

Did you ever notice the SET statements at the beginning of a script?

They are the responsible for the auto-conversion. Every time Qlik loads data, it will check if the data follow the patterns indicated in these SET statements. If positive, it will auto-convert.

See the Help for more info:

"The variables are included at the top of the script of the new QlikView document and substitute operating system defaults for certain number formatting settings at the time of the script execution. They can be deleted, edited or duplicated freely."

Re: Auto-converting string type data to date type data

sammykim_0624 — Thu, 11 Apr 2019 02:32:43 GMT

First of all, thank your replying to my question.

I did check the SET statement and confirm the date type set with what likes to 'YYYY-MM-DD HH:mm:ss' not unix-time.

But the auto-conversion to unix-time type, not to the type set with SET statement was keeping on.

It's so weird...