Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Have a nice day.
I have two date fields CteateDate, UpdateDate here i need to calculate MEDIAN NUMBER DAYS to close a risk by using these two date fields . so how to calculate median in qliksense.
Kindly help in this to calculate median number of daty.. to take to close the risk.
Thanks every one...!
Can you explain with some example?
Thanks for quick reponse MVP
here i need to calculate median number days to close a risk
here i have two dates fields one is CreateDate field and another one is UpdateDate
some risk will take 7 days some risk will take 10, 12, 15... son like (i.e CtreateDate-UpdateDate)
but here i need to calculate median number of days to take to close the risk How?
Perhaps this
Median(Interval(CtreateDate-UpdateDate, 'DD'))
Hi Anil Babu,
Thanks for giving good response , yes it is working fine
if we want apply conditions how can we apply for same median number calculations
if i want to do calculation only for closed risks , i need to calculation median number days to close the risks.
Could you please give the suitable logic Very Thanks....!