Is my script written in the most efficient way?

Wed, 25 Nov 2020 16:16:04 GMT

Good Morning,

I am running a script in qlikview via an ODBC connection. However, when the script runs, it sometimes ends up in a loop and never finishes. I then have to try and rerun the script and it may or may not run.

Could you please let me know if this is the most efficient way to write the script, or if there are any pitfalls I should be avoiding.

My code is as follows:

LOAD CallType, ContactType, ContactUnique, CreatingUser, CreationDate, DiaryDate, DiaryEntryType, LinkingKeyValue, SiteUnique, Subject, UniqueID, 'Database8' AS Database

WHERE Date(CreationDate,'DD/MM/YYYY') >= Today()-90 AND Date(CreationDate,'DD/MM/YYYY') <= Today()-84 ;

SQL SELECT CallType, ContactType, ContactUnique, CreatingUser, CreationDate, DiaryDate, DiaryEntryType, LinkingKeyValue, SiteUnique, Subject, UniqueID FROM JOURNAL0008;

Re: Is my script written in the most efficient way?

sunny_talwar — Thu, 22 Sep 2016 17:12:42 GMT

See our responses here:

Is there a better way to right this script?

topic Is my script written in the most efficient way? in QlikView

Is my script written in the most efficient way?

Re: Is my script written in the most efficient way?