If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
SQL SELECT A."T",
A."ANO",
A.B,
A.P,
A.PL,
A."S",
A."DNO",
A.MA,
A.F1,
A."mck",
A."vu",
A.tk,
B.l AS LI,
A.l AS PLI;
FROM (select "T",
"ANO",
B,
P,
PL,
"S",
"DNO",
MA,
F1,
"mck",
"vu",
tk,
l
from Z.Tek where year(T) >= 2004 and year(S)>=2004) A
left join (
select distinct mck
,S
,l
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
NewTable:
Load
"T",
"ANO",
B,
P,
PL,
"S",
"DNO",
MA,
F1,
"mck",
"vu",
tk,
LI,
PLI;
SQL SELECT A."T",
A."ANO",
A.B,
A.P,
A.PL,
A."S",
A."DNO",
A.MA,
A.F1,
A."mck",
A."vu",
A.tk,
B.l AS LI,
A.l AS PLI;
FROM (select "T",
"ANO",
B,
P,
PL,
"S",
"DNO",
MA,
F1,
"mck",
"vu",
tk,
l
from Z.Tek where year(T) >= 2004 and year(S)>=2004) A
left join (
select distinct mck
,S
,l
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;
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).