topic Re: Best Practice for Date formatting in QlikView

Best Practice for Date formatting

jindrichk — Tue, 16 Apr 2013 08:23:20 GMT

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:

Do it in script - i.e. date (MyDateField, 'DD/MM/YYY')
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

Re: Best Practice for Date formatting

Gysbert_Wassenaar — Tue, 16 Apr 2013 09:56:56 GMT

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.

Re: Best Practice for Date formatting

er_mohit — Tue, 16 Apr 2013 10:22:00 GMT

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

Re: Best Practice for Date formatting

jindrichk — Tue, 16 Apr 2013 11:22:51 GMT

Thanks a lot for those quick replies.