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: 
mloy3
Contributor II
Contributor II

Creating SLA measure based on minimum Date

Hi All, 

I been trying to do a computation for hours (no admin rights). I would ideally like to compute the difference in business days for
- each unique [Work Unit ID]'s [Task Unique key] 8060.1's [Work Unit Process Start Date] AND
- the same [Work Unit Id] has [Task Unique key] 13125.1 & 8067.1's MINIMUM [Work Unit Process Start Date]

I was able to create a custom Dimension for Date Error Flagged via
=aggr(min({<[Tasks.Task_Unique_Key]={13125.1,8067.1}>}[Work Unit Process Start Date]),[Work Unit Entity ID])

However, i was facing significant issues when i try to undertake the subtraction. This should be my output if i am successful. Thank you for your help!

Work Unit IDTask Unique KeyWork Unit Process Start DateEarliest Error measureDate Error FlaggedDifference in Business Days
950925111534.16/24/2019-6/25/2019-
950925112078.16/24/2019-6/25/2019-
950925113125.16/25/2019-6/25/2019-
95092518060.16/26/20196/25/20196/25/20192
95092518067.16/26/2019-6/25/2019-
950923111534.16/24/2019-6/26/2019-
950923112078.16/24/2019-6/26/2019-
950923113125.16/26/2019-6/26/2019-
95092318067.16/26/20196/26/20196/26/2019 
95092318060.16/26/2019-6/26/20191
950922311534.16/24/2019-6/24/2019-
950922312078.16/24/2019-6/24/2019-
950922313125.16/24/2019-6/24/2019-
95092238067.16/26/20196/26/20196/24/2019-
95092238060.16/26/2019-6/24/20193
950922011534.16/24/2019-6/25/2019-
950922012078.16/24/2019-6/25/2019-
950922013125.16/25/20196/25/20196/25/2019-
95092208060.16/25/2019-6/25/20191
95092208067.16/25/2019-6/25/2019-



Labels (1)
1 Reply
mloy3
Contributor II
Contributor II
Author

this is what i came up with but i find that it works for some Work Unit Entity ID but not all.

if(match([Tasks.Task_Unique_Key],8060.1),

networkdays(aggr(min({<[Tasks.Task_Unique_Key]={13125.1,8067.1}>}[Work Unit Process Start Date]),[Work Unit Entity ID]),[Work Unit Process Start Date]))