Sql SubQuery convert into Qlik

[prma7799]

Hi All,

Can anyone please tell me how to covert below SQL sub query into Qlilk?

select  [TYPE], coverage, COVERCODE, EXC, EXCGINAL, SELECTED, deprecated

  from [S_CVG_VER] 

where end_dt = '9999-12-31'  and EFCTV_END_DT = '9999-12-31' 

and [TYPE] in

(select  PACKAGECODE from  s_pkg_ver pk1 ,   

(select distinct packageselected, h_plcy_id   

       from    s_pkg_ver 

       where  end_dt = '9999-12-31'

       and EFCTV_END_DT= '9999-12-31' and h_plcy_id = 47858 ) pk2

where pk1.h_plcy_id = 47858  

and end_dt = '9999-12-31'

and EFCTV_END_DT= '9999-12-31'

and pk1.h_plcy_id = pk2.h_plcy_id

and packagedesc = pk2.packageselected) 

When I am execute this into qlik getting below error 

Anyone can help on this?

[prma7799]

Can anyone help me on this?