topic Re: Minus Datetime in QlikView https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015016#M943016 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be like this,</P><P></P><P><IMG __jive_id="111877" alt="Minus Time.PNG" class="jive-image image-1" src="/legacyfs/online/111877_Minus Time.PNG" style="height: 358px; width: 620px;" /></P><P></P><P>Three expressions,</P><P></P><PRE __default_attr="java" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14531219096558110 jive_text_macro" jivemacro_uid="_14531219096558110" modifiedtitle="true"> <P style="font-size: 13.3333px;">Interval(ClosedDate-CreatedDate,'DD')</P> <P style="font-size: 13.3333px;"></P> <P style="font-size: 13.3333px;">Interval(ClosedDate-CreatedDate,'h')</P> <P style="font-size: 13.3333px;"></P> <P style="font-size: 13.3333px;">Interval(ClosedDate-CreatedDate,'mm')</P> <P style="font-size: 13.3333px;"></P> </PRE><P></P><P>Hope this helps,</P><P>PFA,</P><P>Hirish</P></BODY></HTML> Mon, 18 Jan 2016 12:59:20 GMT HirisH_V7 2016-01-18T12:59:20Z Minus Datetime https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015012#M943012 <HTML><HEAD></HEAD><BODY><P>I have a trouble with minusing 2 datetime field. Can anyone help me to solve this problem, please? i will attached my file into this thread.</P></BODY></HTML> Mon, 18 Jan 2016 10:04:51 GMT https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015012#M943012 2016-01-18T10:04:51Z Re: Minus Datetime https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015013#M943013 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Interval(Sum(Aggr(ClosedDate-CreatedDate, CaseCode)), 'D hh:mm:ss')</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="111863" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111863_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 18 Jan 2016 11:59:21 GMT https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015013#M943013 sunny_talwar 2016-01-18T11:59:21Z Re: Minus Datetime https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015014#M943014 <HTML><HEAD></HEAD><BODY><P>I would <STRONG>avoid aggr()</STRONG> and use:</P><P></P><P>=Interval(Sum(ClosedDate-CreatedDate <SPAN style="text-decoration: line-through;">, CaseCode</SPAN>), 'D hh:mm:ss')</P><P></P><P>Corrected</P></BODY></HTML> Mon, 18 Jan 2016 12:13:31 GMT https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015014#M943014 tresB 2016-01-18T12:13:31Z Re: Minus Datetime https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015015#M943015 <HTML><HEAD></HEAD><BODY><P>I guess you are right <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />. Just a minor correction though, you forgot to remove the aggregated dimension from my expression:</P><P></P><P><STRONG>=Interval(Sum(ClosedDate-CreatedDate), 'D hh:mm:ss')</STRONG></P></BODY></HTML> Mon, 18 Jan 2016 12:31:29 GMT https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015015#M943015 sunny_talwar 2016-01-18T12:31:29Z Re: Minus Datetime https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015016#M943016 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>May be like this,</P><P></P><P><IMG __jive_id="111877" alt="Minus Time.PNG" class="jive-image image-1" src="/legacyfs/online/111877_Minus Time.PNG" style="height: 358px; width: 620px;" /></P><P></P><P>Three expressions,</P><P></P><PRE __default_attr="java" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14531219096558110 jive_text_macro" jivemacro_uid="_14531219096558110" modifiedtitle="true"> <P style="font-size: 13.3333px;">Interval(ClosedDate-CreatedDate,'DD')</P> <P style="font-size: 13.3333px;"></P> <P style="font-size: 13.3333px;">Interval(ClosedDate-CreatedDate,'h')</P> <P style="font-size: 13.3333px;"></P> <P style="font-size: 13.3333px;">Interval(ClosedDate-CreatedDate,'mm')</P> <P style="font-size: 13.3333px;"></P> </PRE><P></P><P>Hope this helps,</P><P>PFA,</P><P>Hirish</P></BODY></HTML> Mon, 18 Jan 2016 12:59:20 GMT https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015016#M943016 HirisH_V7 2016-01-18T12:59:20Z Re: Minus Datetime https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015017#M943017 <HTML><HEAD></HEAD><BODY><P>Thank all very much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Tue, 19 Jan 2016 07:57:17 GMT https://community.qlik.com/t5/QlikView/Minus-Datetime/m-p/1015017#M943017 2016-01-19T07:57:17Z