How to calculate Median Number of days between the date fields in Qliksense?

[narayanaqlik]

Hi All Experts in Qlik,

Please give me the good solution 

I have CtreatedDate and UpdatedDate, RiskIDs 

Here i need to  calculate Median number of days to close the Risk for last 12 months in bar chart month on month 

Please help here with good expression

[JaMajka1]

Hello,

could you upload a dummy app?

Maria

[narayanaqlik]

Hi Jamajka

Yes, if My fields are like this

ID,  CreateDate,   Clsed Date

101, 05/01/2019,  03/02/2019

102 , 12/12/2018,  05/03/2020

103, 18/02/2017,  15/07/2019

Like this i have dates , Here i need to calculate median number days in a month like that for last 12 months

How to calculate

[JaMajka1]

Thanks for the example. So what is the result you want to have on this data? If you can describe the calculation process (not by using Qlik script, only by words) it will help me to understand ;).

BR,

Maria

[narayanaqlik]

Hi Jamajka1,

I have risks open date field and risks closed date fields are there. So here risks are open in one month and it may closed another month or next year like that we have so many risks are opening and closing 

So here i need to calculate what are median number of days taken to close the risks month over month