topic Nested select in Qlik sense from qvds in App Development

Nested select in Qlik sense from qvds

ChethanKumar — Wed, 20 Oct 2021 05:20:03 GMT

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"

Re: Nested select in Qlik sense from qvds

Or — Wed, 20 Oct 2021 13:51:41 GMT

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.