Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sammykim_0624
New Contributor

Auto-converting string type data to date type data

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?

 

2 Replies
Partner
Partner

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

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."

sammykim_0624
New Contributor

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

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...