Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Long load time due to date format

Hi All,

We are retrieving data from the SQL server database. It seems that the date is in the string format.

The current transformation for the date in Qlikview is Text (Date (datetime, 'DD.MM.YYYY')) as DateTime which is consuming more time.

Could you please suggest any alternative for this.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Long load time due to date format


@deepakqlikview_123 wrote:

.. Text (Date (datetime, 'DD.MM.YYYY')) as DateTime ..


Your code looks not very useful to me. If you need to convert a text field to date field, you should use date#() instead. And why text()?

View solution in original post

1 Reply
Highlighted
MVP
MVP

Re: Long load time due to date format


@deepakqlikview_123 wrote:

.. Text (Date (datetime, 'DD.MM.YYYY')) as DateTime ..


Your code looks not very useful to me. If you need to convert a text field to date field, you should use date#() instead. And why text()?

View solution in original post