Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is my script written in the most efficient way?

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;

1 Reply