Iam having the problem to convert the nested select query from SQL in to Qlik. as this query has multiple select statement.
1)select r.Info_id as info_id, d.branch_cd as Branch,f.payment as DueAmount,
(select COALESCE(max(RECIVEDDATE01/2000')) from payment where paymentid in (select payment id from receipts where payment id = A.paymentid) and and receiptdate >= lastyear_firstday and receiptdate <= lastyear_lastday) as Receiptdate,
