topic Re: How to best define a broken call by considering a difference between two dates. in QlikView https://community.qlik.com/t5/QlikView/How-to-best-define-a-broken-call-by-considering-a-difference/m-p/537075#M200723 <HTML><HEAD></HEAD><BODY><P>See attached example. </P></BODY></HTML> Wed, 18 Sep 2013 13:12:44 GMT Gysbert_Wassenaar 2013-09-18T13:12:44Z How to best define a broken call by considering a difference between two dates. https://community.qlik.com/t5/QlikView/How-to-best-define-a-broken-call-by-considering-a-difference/m-p/537074#M200722 <HTML><HEAD></HEAD><BODY><P><BR />Hello;</P><P></P><P>I am interested to understand how we need to setup this kind of analysis in QV.</P><P></P><P>We are looking to understand how many broken calls we have per equipment over a period of time.</P><P>A broken call means that the customer contacted us within the 5 days after the start of a previous intervention.</P><P>If there is more than 5 days between the start of two intervention the intervention is considered as a normal intervention and not a broken call.</P><P></P><P>This can be easily set up in Excel, but what about QV. How should we identify the calculation of the difference between the last intervention start date and the previous intervention start date.</P><P></P><P>Please find hereby an example in excel.</P><P></P><P>Thanks to all of you in advance. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Kristel</P></BODY></HTML> Wed, 18 Sep 2013 12:36:01 GMT https://community.qlik.com/t5/QlikView/How-to-best-define-a-broken-call-by-considering-a-difference/m-p/537074#M200722 2013-09-18T12:36:01Z Re: How to best define a broken call by considering a difference between two dates. https://community.qlik.com/t5/QlikView/How-to-best-define-a-broken-call-by-considering-a-difference/m-p/537075#M200723 <HTML><HEAD></HEAD><BODY><P>See attached example. </P></BODY></HTML> Wed, 18 Sep 2013 13:12:44 GMT https://community.qlik.com/t5/QlikView/How-to-best-define-a-broken-call-by-considering-a-difference/m-p/537075#M200723 Gysbert_Wassenaar 2013-09-18T13:12:44Z Re: How to best define a broken call by considering a difference between two dates. https://community.qlik.com/t5/QlikView/How-to-best-define-a-broken-call-by-considering-a-difference/m-p/537076#M200724 <HTML><HEAD></HEAD><BODY><P>Many thanks this is really helpfull!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/cool.png" /></P></BODY></HTML> Thu, 19 Sep 2013 07:39:03 GMT https://community.qlik.com/t5/QlikView/How-to-best-define-a-broken-call-by-considering-a-difference/m-p/537076#M200724 2013-09-19T07:39:03Z