SQL querry to QVW

Wed, 29 May 2013 11:16:07 GMT

I have a SQL querry, where there is filter for date and branches, the querry works fine in qvw application

but whn i remove the filter for date and branch ( Bold letters ),

the querry doesnt work in qvw,

pls find the querry, need help/suggestions on this Error Msg : Execution failed Reload old data

SELECT R.AUDITOR_REMARKS,
R.QUESTION,
PKG_AUDIT_NEW.F_GETSUBANS(R.SR_NO) SUB_ANS,
M.SERVICE_CENTRE,
M.SAMPLE_MONTH,
PKG_AUDIT_NEW.F_UNIT_NAME(M.BRANCH) BRANCH,
C.PROCESS,
C.STATUS,
M.FILE_NO,

M.LOAN_PRODUCT,
R.QUESTION_CATEGORY,
COUNT(*) CNT
FROM AUDIT_SAMPLE_MASTER M, AUDIT_QUEST_RESPONSE R, COMPLIANCE_MASTER C
WHERE
M.BRANCH IN ('201')
AND TRUNC(M.SAMPLE_MONTH) IN ('01-JAN-2013')
AND R.AUDIT_MASTER_SR_NO = M.SR_NO
AND C.SECTION = R.SECTION
AND C.QUESTION_NO = R.QUESTION_NO
AND C.ANS = R.AUDITOR_ANSWER
AND NVL(C.QUESTION_CAPACITY,'A')=NVL(R.CUST_CAPACITY,'A')
AND C.VERSION = 2
AND NVL(C.SUB_ANS, 'A') = NVL(PKG_AUDIT_NEW.F_GETSUBANS(R.SR_NO), 'A')
GROUP BY R.AUDITOR_REMARKS,
M.BRANCH,
C.PROCESS,
C.STATUS,
M.LOAN_PRODUCT,
R.QUESTION,
R.AUDITOR_ANSWER,
R.SR_NO,
M.SERVICE_CENTRE,
M.SAMPLE_MONTH,
M.FILE_NO,
R.QUESTION_CATEGORY;

topic SQL querry to QVW in QlikView

SQL querry to QVW