Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
jindrichk
New Contributor II

Best Practice for Date formatting

Hi,

I would like to find the way how to format data to date format so they will load as fast as possible.

I can see two ways:

  1. Do it in script - i.e. date (MyDateField, 'DD/MM/YYY')
  2. Do it in Properties / Number / Override Document Settings for each displayed field.

The case is to speed up load / reload time to max. I don't consider design time right now. The goal is to format several fields to several format, so changing Document Settings is not a way.

Thanks for all comments,

Jindra

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Best Practice for Date formatting

If you want maximum load performance and don't care about UI performance then don't format it in the script. I doubt you'll notice any difference in load time though. Best practise is to fix things as much as possible in the script so you have the cleanest data model (and data) and best performance in the UI.


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: Best Practice for Date formatting

If you want maximum load performance and don't care about UI performance then don't format it in the script. I doubt you'll notice any difference in load time though. Best practise is to fix things as much as possible in the script so you have the cleanest data model (and data) and best performance in the UI.


talk is cheap, supply exceeds demand
er_mohit
Honored Contributor II

Re: Best Practice for Date formatting

Do it in script as use of

date(date#(datefield,'DD/MM/YYYY'),'DD-MM-YYYY') as Date

here 1st format is your date field format and 2nd one is which format is you desired

hope it helps you

jindrichk
New Contributor II

Re: Best Practice for Date formatting

Thanks a lot for those quick replies.