Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
j_qlikview
Contributor

Nested Select(SQL) to Qlikview

HI,

 

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,

Thanks in Advance,

J