Discussion Board for collaboration on QlikView Scripting.
I want to implement below query in qlikview scripting .
DEPTNO IN (SELECT DEPTNO FROM DEPT WHERE CLASS = 'DESIGNATION')
Scenerio: i already generated dept qvd . so im having dept qvd.
1st qvd ----select * from dept;
2nd qvd : Now i want to create one more qvd based on below query . Please help to solve this.
LOAD DEPT FROM DEPT.qvd (qvd) WHERE CLASS = 'DESIGNATION'
LOAD * FROM DEPT.qvd (qvd) WHERE EXISTS(DEPT);
DROP TABLE Temp;
Store Result into Result.qvd(qvd);