Convert sql script to Qlik Sense

[maasool]

select ai.source, sum(api.amt)

from acc_payment ap, acc_payment_item api, acc_item ai

where ap.acc_payment_no = 117227

and ap.acc_payment_no = api. acc_payment_no

and api.acc_item_no = ai.acc_item_no

and ai.source in (1, 3)

group by ai.source;

[asinha1991]

select ai.source, sum(api.amt)
from acc_payment ap, acc_payment_item api, acc_item ai
where ap.acc_payment_no = 117227
and ap.acc_payment_no = api. acc_payment_no
and api.acc_item_no = ai.acc_item_no
and ai.source in (1, 3)
group by ai.source;

store data for each table in QVD

AI:
Load
SOURCE,acc_item_no FROM acc_item.qvd where match(source,1,3);

innerjoin(AI):
Load AMT,acc_item_no from acc_payment_item.qvd;

innerjoin(AI)
Load acc_payment_no from acc_payment_no.qvd;

FinalTable;
Load sum(AMT) as sum_amt sourceRESIDENT AI Group by source;

Drop table AI;

[maasool]

Thanks for trying, but it's not working.