Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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).
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).