Optimize load time

[Qliksense_77]

Hi,

The script below takes a long time to load. Anybody knows how to optimize the load?

The purpose of the script is to create a table with sale_ids that contains two specific salesnames on the same date.

chkIdDate:
LOAD chkIdDate
Where Count=2;
LOAD chkIdDate,
count(distinct id_salesname) as Count
group by chkIdDate;

LOAD Id_sale &'_'&id_date as chkIdDate
,id_salesname
FROM...

where  

(Applymap('Apply_department', id_department, ':') <> ':')

and

(Applymap('Apply_salesname', id_salesname, ':') <> ':')

;