Nested select in Qlik Sense from qvds

[ChethanKumar]

Hi All,

Am new to this Qlik Sense.

Is it possible to load the data using nested sql select from qvd file. Kindly help on the below query to converting into qlik load.

"select distinct a.ID,a.Name,max(c.EndDate)
from [qvd1.qvd] (qvd) a
left join [qvd2.qvd] (qvd) c on c.ID=a.ID
where a.ID not in (Select distinct b.ID from [qvd1.qvd] (qvd) b where b.EndDate > Today())
group by a.ID"