sql in function to qlikview scripting

[#1]

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

[Gysbert_Wassenaar]

Temp:

LOAD DEPT FROM DEPT.qvd (qvd) WHERE CLASS  =  'DESIGNATION'

Result:

LOAD * FROM DEPT.qvd (qvd) WHERE EXISTS(DEPT);

DROP TABLE Temp;

[pipuindia99]

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;