topic Re: Speed up Load in QlikView

Speed up Load

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I am currently trying to load a small table in Qlikview that extracts a created date from a large record set where the record ID exists in another table.

The load statement I am using is below. The first record I want to extract starts after caseID 1597000 hence trying to put the greater than statement in. While the load works it takes over 2 hours to run. can anyone suggest a quicker way to perform the load. I have tried a mapped load and also a join but they also take a long time to run. For info the extract to date will be about 1000 records but will grow daily.

if(caseID>1597000,caseID),

       Date(createdDateTime, 'DD/MM/YYYY') as createdDate

where exists (caseID,caseID);

SQL SELECT

    caseID,

    createdDateTime

    FROM myDatabase;

Thanks for your help.

Re: Speed up Load

simospa — Mon, 19 Oct 2015 14:53:07 GMT

Hi,

did you try with

SQL SELECT

caseID,

Date(createdDateTime, 'DD/MM/YYYY') as createdDate

FROM myDatabase

WHERE caseID>159700;

Let us know...

Re: Speed up Load

rubenmarin — Mon, 19 Oct 2015 14:55:34 GMT

Hi Clive, to speed up set the WHERE clause in the SQL SELECT:

SQL SELECT
    caseID,
    createdDateTime
    FROM myDatabase Where CaseID>1597000;

Re: Speed up Load

Anonymous — Tue, 20 Oct 2015 06:50:46 GMT

Thanks Ruben this worked great I did not think to add the greater than clause in the SQL statement I thought it had to be in the load statement. the load time has gone from approximately 2 hours to 30 seconds.

Re: Speed up Load

Anonymous — Tue, 20 Oct 2015 06:54:27 GMT

Thanks Simone you hit the nail on the head with this one. I went with Rubens answer but only because I prefer to keep my field renaming in the load statement rather than the SQL statement (I do not have an idea if that makes a difference at all). The load has gone from approximately 2 hours to 30 seconds.

Re: Speed up Load

simospa — Tue, 20 Oct 2015 07:31:04 GMT

It's ok.

Have a nice day!