Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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]))