topic Difference between two dates in QlikView https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471426#M565260 <HTML><HEAD></HEAD><BODY><P>Hi - </P><P></P><P>I am trying to create single line chart that will display the difference between Clearing Date &amp; Posting date by Regrion. For some reasons when selecting one dimension and adding single calculated measure, values are not appearing on my chart. </P><P></P><P>Any help?</P><P></P><P>As my <STRONG>Dimension I </STRONG>am selection <STRONG>Region </STRONG></P><P>and this is what i have for my expression: </P><P><STRONG>interval("[Clearing Date].[Date].[Date].[MEMBER_CAPTION]"-"[Posting Date].[Date].[Date].[MEMBER_CAPTION]",'dd') </STRONG></P><P></P><P>Thank you </P><P></P><P>Z</P></BODY></HTML> Fri, 28 Dec 2012 20:30:39 GMT 2012-12-28T20:30:39Z Difference between two dates https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471426#M565260 <HTML><HEAD></HEAD><BODY><P>Hi - </P><P></P><P>I am trying to create single line chart that will display the difference between Clearing Date &amp; Posting date by Regrion. For some reasons when selecting one dimension and adding single calculated measure, values are not appearing on my chart. </P><P></P><P>Any help?</P><P></P><P>As my <STRONG>Dimension I </STRONG>am selection <STRONG>Region </STRONG></P><P>and this is what i have for my expression: </P><P><STRONG>interval("[Clearing Date].[Date].[Date].[MEMBER_CAPTION]"-"[Posting Date].[Date].[Date].[MEMBER_CAPTION]",'dd') </STRONG></P><P></P><P>Thank you </P><P></P><P>Z</P></BODY></HTML> Fri, 28 Dec 2012 20:30:39 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471426#M565260 2012-12-28T20:30:39Z Re: Difference between two dates https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471427#M565261 <HTML><HEAD></HEAD><BODY><P>Try the expression</P><P></P><P>Floor([Clearing Date]) - Floor([Posting Date])</P></BODY></HTML> Sat, 29 Dec 2012 00:19:35 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471427#M565261 nagaiank 2012-12-29T00:19:35Z Re: Difference between two dates https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471428#M565262 <HTML><HEAD></HEAD><BODY><P>no that did not work. </P></BODY></HTML> Wed, 09 Jan 2013 18:28:34 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471428#M565262 2013-01-09T18:28:34Z Re: Difference between two dates https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471429#M565263 <HTML><HEAD></HEAD><BODY><P>Here is an example of my file</P></BODY></HTML> Wed, 09 Jan 2013 18:50:23 GMT https://community.qlik.com/t5/QlikView/Difference-between-two-dates/m-p/471429#M565263 2013-01-09T18:50:23Z