Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
LibX
Contributor
Contributor
‎2021-12-21 06:06 AM

Median

Hi All,

I need your support and your help !  

I have to monitor the median interval (median numbers of days) to respond to my stakeholders. 

Basically, I have a list of tasks (tasks 1, 2, 3..., 45) and for each task I have two dates to monitor : the date when the task has been requested (Actual Start Task date) and the date when the completeness of the task as been sent to the stakeholders (Completeness Notification date). I would like to know how long it takes to complete a task expressed as a Median.

In Qlik, I have coded the formula as followed : 

median([Completeness Notification date]-[Actual Start Task date])

 However, the median I obtain in Qlik does not correspond to the median I can found in Excel.

But, I don't understand why. Can someone help me? 

Thanks 

Xavier

 

 

 

 

 

 

244 Views
0 Likes
0 Replies