Need Help Regarding a Query Logic

qliktoview123 — Wed, 25 Nov 2020 16:16:04 GMT

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

topic Need Help Regarding a Query Logic in QlikView