Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
narayanaqlik
Creator
Creator

how to calculate median time taken between two date fields (Like CreateDate and ClosedDate)

Hi All,

i need to calculate median number of days to close the risks or issues , there i have one CreatedDate field and  CloseDate field then here i need to calculate month on month like if any risk is created in last month and it could be closed next month, that we need to calculate in which month it has been closed from created month.

 

Could you please give the correct calculation 

 

Thanks to every one 

0 Replies