Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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

 

 

4 Replies
Highlighted
Partner
Partner

Hello,

could you upload a dummy app?

 

Maria

Highlighted
Creator
Creator

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

 

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

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