If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
SQL SELECT A."T",
B.l AS LI,
A.l AS PLI;
FROM (select "T",
from Z.Tek where year(T) >= 2004 and year(S)>=2004) A
left join (
select distinct mck
from Z.Tek where year(T) >= 2004 and year(S)>=2004 and ano like '0%') B
on A.mck = B.mck AND A.S = B.S;
How implement this in qliksense script, does it support inner load similar to inner select in sql?
Try like this
Store NewTable into NewTable.qvd(qvd);
Then used above QVD in your data model.
No Sir, I have already created the qvd for Z.Tek, without any inner select. I want to perform this inner select kind of function in Load (fetching data from qvd).