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"

[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"

[Or]

Something along the lines of this, using Exists:

Load distinct ID from qvd1.qvd(qvd) where EndDate > Today();

Load distinct ID, Name, max(EndDate)

from qvd1.qvd(qvd)

Where NOT exists ID

GROUP BY ID, Name;

Note that using these WHERE conditions on your QVD loads will result in them not being optimized, so this won't be very fast. Depending on your specific case it may be better to load the entire QVD first and then use Resident Load for the individual tasks.