Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
qliktoview123
New Contributor II

Need Help Regarding a Query Logic

Hello,

I am not able to get the query logic ,Please help me out to run the query logic in qlikview.

QUERY:

 

SELECT Count(*)

 

FROM PS_BSL_JOB_CI_VW A

 

WHERE A.EMPL_RCD=0

 

AND A.EFFDT = (SELECT Max(EFFDT) FROM PS_BSL_JOB_CI_VW WHERE EMPLID=A.EMPLID AND EMPL_RCD=A.EMPL_RCD AND EFFDT <= '01JAN2015')

 

AND A.EFFSEQ = (SELECT Max(EFFSEQ) FROM PS_BSL_JOB_CI_VW WHERE EMPLID=A.EMPLID AND EMPL_RCD=A.EMPL_RCD AND EFFDT=A.EFFDT)

 

AND A.EMPL_STATUS = 'A';

I have to implement above query logic in the below table

Data:
LOAD EMPLID,
EMPL_RCD,
EFFDT,
EFFSEQ,
EMPL_STATUS

FROM
D:\Qlikview\QVDs\JOB_CI.qvd

Thanks