qlikview query taking long time to execute -

i loading data in qlikview through flat file, data loaded in table called imported. table imported table called transaction_details loads data.

the query using

transaction_details: load   key,   line_number,   key&line_number line_key,    currency,    exchrate,   account,   [account text],   [cost ctr],    [wbs element],   [line text],    [tc amount],    [lc amount],    [d/c],    [tax code],   [account type],   cocode   resident imported ; 

after want calculations in table , join main table transaction_details

the table have created calculations called sums:

sums: load     distinct key resident  transaction_details;   left join (sums)  load  key,  sum([lc amount]) [lc amount sum]  resident transaction_details  group key; 

the original table transactions_details have around 400 million rows, reason simple group , sum in sums table taking long time, running past 4 hours now. there better way of doing , , can 1 guide me qlikview query performance.

you don't need first sums load statement, try:

sums:  load  key,  sum([lc amount]) [lc amount sum]  resident transaction_details  group key; 

you join other calculations table.

however, wonder why want because qlikview aggregation on fly in charts.