https://community.qlik.com/t5/App-Development/How-to-calculate-duration-b-w-two-date-fields-of-two-different/m-p/1650034#M48490 <P>Hi All,</P><P>I have two table with Create table has contain&nbsp; RiskCreateDate, if any action hs been taken on perticular Risk of product it will be updated in Action table with the like ActionctreationDate, so i need to calculate duration between the Risk creation and Action taken Month on Month for last 12 months duration need to display</P><P>I have done like Interval(ActionctreationDate-RiskCreateDate,'hh:mm:ss') //Both the date formats same format.</P><P>How to show month on month on bar chart or line chart with dimension as month</P><P>Could any one of you help in this ..</P><P>Thanks for your great help...</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 22 Nov 2019 11:03:57 GMT narayanaqlik 2019-11-22T11:03:57Z https://community.qlik.com/t5/App-Development/How-to-calculate-duration-b-w-two-date-fields-of-two-different/m-p/1650034#M48490 <P>Hi All,</P><P>I have two table with Create table has contain&nbsp; RiskCreateDate, if any action hs been taken on perticular Risk of product it will be updated in Action table with the like ActionctreationDate, so i need to calculate duration between the Risk creation and Action taken Month on Month for last 12 months duration need to display</P><P>I have done like Interval(ActionctreationDate-RiskCreateDate,'hh:mm:ss') //Both the date formats same format.</P><P>How to show month on month on bar chart or line chart with dimension as month</P><P>Could any one of you help in this ..</P><P>Thanks for your great help...</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 22 Nov 2019 11:03:57 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-duration-b-w-two-date-fields-of-two-different/m-p/1650034#M48490 narayanaqlik 2019-11-22T11:03:57Z