Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

sql in function to qlikview scripting

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

2 Replies
MVP & Luminary
MVP & Luminary

Re: sql in function to qlikview scripting

Temp:

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

Result:

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

DROP TABLE Temp;


talk is cheap, supply exceeds demand
pipuindia99
Contributor III

Re: sql in function to qlikview scripting

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;