Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Normal Distribution Curve

Hi,

I used the following expression to calculate timestamp difference in hours and it works well. Actually it calculate time difference in working hours based on working days (working hours 9-5 and working days Monday to Friday).  Is there any easy expression to get the same result.

Also, I want to show this working hours result in normal distribution curve and some applications take longer but most of them take short time.

 

avg (fabs (interval(((Networkdays(Date(AnalysedFirstTimestamp,'DD/MM/YYYY hh:mm:ss'),Date(ReferralFirstTimestamp,'DD/MM/YYYY hh:mm:ss'

)) -2)*'$(vWorkDay)')   if(frac(date(AnalysedFirstTimestamp))<num('$(vQuitTime)'),if(frac(date(AnalysedFirstTimestamp))>num'$(vStartTime)'),Date#(date(floor(AnalysedFirstTimestamp),'DD/MM/YYYY') & '$(vQuitTime)' ,'DD/MM/YYYYhh:mm:ss')-Date

(AnalysedFirstTimestamp,'DD/MM/YYYY hh:mm:ss'),Date#(date(floor(AnalysedFirstTimestamp),'DD/MM/YYYY') & '$(vQuitTime)' ,'DD/MM/YYYYhh:mm:ss')-Date#(date(floor(AnalysedFirstTimestamp),'DD/MM/YYYY') & '$(vStartTime)' ,'DD/MM/YYYYhh:mm:ss')),0)   if (frac(date(ReferralFirstTimestamp))>num('$(vStartTime)'),if(frac(date(ReferralFirstTimestamp

))<num('$(vQuitTime)'),(Date(ReferralFirstTimestamp,'DD/MM/YYYY hh:mm:ss')-Date#(date(floor(ReferralFirstTimestamp),'DD/MM/YYYY'

) & '$(vStartTime)','DD/MM/YYYYhh:mm:ss')),Date#(date(floor(ReferralFirstTimestamp),'DD/MM/YYYY') & '$(vQuitTime)','DD/MM/YYYYhh:mm:ss')-Date#

(date(floor(ReferralFirstTimestamp),'DD/MM/YYYY') & '$(vStartTime)','DD/MM/YYYYhh:mm:ss')),0), 'hh:mm:ss')))*24

0 Replies