topic sql in function to qlikview scripting in QlikView

sql in function to qlikview scripting

Thu, 22 Dec 2016 17:08:45 GMT

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

Re: sql in function to qlikview scripting

Gysbert_Wassenaar — Thu, 22 Dec 2016 17:31:44 GMT

Temp:

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

Result:

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

DROP TABLE Temp;

Re: sql in function to qlikview scripting

pipuindia99 — Tue, 03 Jan 2017 15:32:20 GMT

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;