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: 
Alarkis
Contributor III
Contributor III

Expression for this SQL query

Hello All,

I want to create this Query with expression:

select
sum( case when Total_Time <= :T Then 1 Else 0 End ) / Count(1) * 100 Perc_Acheived
From
(
SELECT application_no, SUM (work_time) total_time
FROM FN_WFLOG_MV
WHERE
(application_no, applicant_no) IN
(SELECT application_no, applicant_no
FROM FN_WFLOG_MV
WHERE WF_TASK_NAME = 'Task1'
AND TO_CHAR (ACTION_DATE, 'YYYYQ') = :Q
AND USERID IS NOT NULL
AND TO_WF_TASK_NAME = 'To_Task1'
AND ACTION_NAME = 'Action1')
AND TO_CHAR (ACTION_DATE, 'YYYYQ') = :Q
AND DEPT_NAME = 'DEPT1'
AND WF_TASK_NAME = 'TASK1'
GROUP BY application_no

T is a variable for Days

Q is for Year and Quarter

output is a percentage...

Labels (2)
0 Replies