Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SQL querry to QVW

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;

0 Replies