Normal Distribution Curve

Tue, 15 Jul 2014 15:58:10 GMT

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

topic Normal Distribution Curve in QlikView

Normal Distribution Curve