Sum for if expression

rathorep — Fri, 14 Mar 2025 20:49:07 GMT

I have below expression:

//sum(Aggr(
if(
if(
if
(NetWorkDays(date(Above(TOTAL [Field Modified Date],1),'DD/MM/YYYY'),Date([Field Modified Date],'DD/MM/YYYY')-1)

(floor(sum(Aggr(
if
("Field Modified Group Code"=$(vFieldModifiedGroupCode),
Interval(sum(Aggr(Interval(Rangemax(Interval((Above(TOTAL [Field Modified Date],1) - [Field Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Win@proach Ticket Number],([Field Modified Date], (NUMERIC)))),'d.hh:mm'),0
),[Win@proach Ticket Number],([Field Modified Date],(NUMERIC))))))
,

(((
(interval(sum(Aggr(
if
("Field Modified Group Code"=$(vFieldModifiedGroupCode),
Interval(sum(Aggr(Interval(Rangemax(Interval((Above(TOTAL [Field Modified Date],1) - [Field Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Win@proach Ticket Number],([Field Modified Date], (NUMERIC)))),'d.hh:mm'),0
),[Win@proach Ticket Number],([Field Modified Date],(NUMERIC)))),'d.hh:mm')))
-
interval(
(round(sum(Aggr(
if
("Field Modified Group Code"=$(vFieldModifiedGroupCode),
Interval(sum(Aggr(Interval(Rangemax(Interval((Above(TOTAL [Field Modified Date],1) - [Field Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Win@proach Ticket Number],([Field Modified Date], (NUMERIC)))),'d.hh:mm'),0
),[Win@proach Ticket Number],([Field Modified Date],(NUMERIC))))))
-
(NetWorkDays(date(Above(TOTAL [Field Modified Date],1),'DD/MM/YYYY'),Date([Field Modified Date],'DD/MM/YYYY')-1)),'d.hh.mm')
))
,

(if
("Field Modified Group Code"=$(vFieldModifiedGroupCode),
(sum(Aggr(Interval(Rangemax(Interval((Above(TOTAL [Field Modified Date],1) - [Field Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Win@proach Ticket Number],([Field Modified Date], (NUMERIC))))),0
)))>'2.75' and Remarks <>'Exception','Exceeded Target',if((([Field Modified Group Code]<>$(vFieldModifiedGroupCode)) and Remarks='Exception'),'NA','Meet Target'))
='Exceeded Target', count( {<[Field Modified Group Code]={$(vFieldModifiedGroupCode)} , [Record Type] = {'IR'}, Severity={'Medium'}>}distinct [Win@proach Ticket Number])
,0)

//,[Win@proach Ticket Number]))

Result I am getting is:

Win@proach Ticket Number	Field Modified Date	With the Expression shared
197264	7/24/2020 14:38	0
197264	7/27/2020 7:07	0
197264	7/30/2020 13:21	1
197264	7/30/2020 14:27	0
197264	8/18/2020 23:12	0
203257	11/10/2020 9:18	0
203257	11/10/2020 9:22	0
203257	11/25/2020 13:07	1
203257	11/26/2020 12:39	0
203257	11/26/2020 13:17	0
203257	12/2/2020 0:11	0

Now i need to calculate sum on top of this, so when i am un commenting first and last bold lines, Its giving 0 in full column and total also is coming 0.

Sum should be 2

Could any one help me urgently please.

Re: Sum for if expression

TimGarrod — Mon, 04 Jan 2021 15:44:40 GMT

Hi @rathorep - you have posted this question in the Qlik Compose for Data Warehouses forum.

Since this appears to be QlikSense or QLikView related, I recommend posting this question under the appropriate Data Analytics Forum. (Unfortunately, I can't move it for you).

topic Re: Sum for if expression in Qlik Compose

Sum for if expression

Re: Sum for if expression