Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to implement below query in qlikview scripting .
SELECT
*
FROM
DEPT
WHERE
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.
SELECT
*
FROM
DEPT
WHERE
DEPTNO IN (SELECT DEPTNO FROM DEPT WHERE CLASS = 'DESIGNATION')
Thanks
Prakash
Temp:
LOAD DEPT FROM DEPT.qvd (qvd) WHERE CLASS = 'DESIGNATION'
Result:
LOAD * FROM DEPT.qvd (qvd) WHERE EXISTS(DEPT);
DROP TABLE Temp;
Temp:
LOAD DEPT FROM DEPT.qvd (qvd) WHERE CLASS = 'DESIGNATION'
Result:
LOAD * FROM DEPT.qvd (qvd) WHERE EXISTS(DEPT);
Store Result into Result.qvd(qvd);
DROP TABLE Temp;