https://community.qlik.com/t5/QlikView/DATEDIFF-function-in-qlik-sense/m-p/2053996#M1223090 <P>Hi community,</P> <P>Iam new to qlik sense and starting to evaluate it as a BI Tool and trying to do a simple calculation with DATADIFF, but DATEDIFF is not a valid function in qlik ,can please help me to convert SQL code to qlik sense script ?</P> <P>"Technical CO2" / 365.0 *&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case when (datediff(DAY, case when DateFinExo &gt; min(Calcul_Datedebut)&nbsp; then DateFinExo else min(Calcul_Datedebut) end,&nbsp; max(Calcul_DateFin) )+1 &lt;= 0) or (datediff(DAY, min(Calcul_Datedebut),max(Calcul_DateFin)) &lt; 30) then 0</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else datediff(day, case when DateFinExo &gt; min(Calcul_Datedebut)&nbsp; then DateFinExo else min(Calcul_Datedebut) end,&nbsp; max(Calcul_DateFin) )+1</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> Tue, 28 Mar 2023 09:37:13 GMT Aravindvunnam 2023-03-28T09:37:13Z https://community.qlik.com/t5/QlikView/DATEDIFF-function-in-qlik-sense/m-p/2053996#M1223090 <P>Hi community,</P> <P>Iam new to qlik sense and starting to evaluate it as a BI Tool and trying to do a simple calculation with DATADIFF, but DATEDIFF is not a valid function in qlik ,can please help me to convert SQL code to qlik sense script ?</P> <P>"Technical CO2" / 365.0 *&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case when (datediff(DAY, case when DateFinExo &gt; min(Calcul_Datedebut)&nbsp; then DateFinExo else min(Calcul_Datedebut) end,&nbsp; max(Calcul_DateFin) )+1 &lt;= 0) or (datediff(DAY, min(Calcul_Datedebut),max(Calcul_DateFin)) &lt; 30) then 0</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else datediff(day, case when DateFinExo &gt; min(Calcul_Datedebut)&nbsp; then DateFinExo else min(Calcul_Datedebut) end,&nbsp; max(Calcul_DateFin) )+1</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> Tue, 28 Mar 2023 09:37:13 GMT https://community.qlik.com/t5/QlikView/DATEDIFF-function-in-qlik-sense/m-p/2053996#M1223090 Aravindvunnam 2023-03-28T09:37:13Z https://community.qlik.com/t5/QlikView/DATEDIFF-function-in-qlik-sense/m-p/2054008#M1223091 <P>In Qlik, you can simply subtract or add dates. Date1 - Date2 will give you the difference in days (if they're a timestamp, it'll include the time aspect, e.g. 1.5 is a day and a half).</P> Tue, 28 Mar 2023 10:07:03 GMT https://community.qlik.com/t5/QlikView/DATEDIFF-function-in-qlik-sense/m-p/2054008#M1223091 Or 2023-03-28T10:07:03Z https://community.qlik.com/t5/QlikView/DATEDIFF-function-in-qlik-sense/m-p/2054307#M1223101 <P>Maybe something like this?</P> <LI-CODE lang="markup">[Technical CO2]/365.0 * If(Max(Calcul_DateFin)-RangeMax(DateFinExo,Min(Calcul_Datedebut))+1 &lt;= 0 or Max(Calcul_DateFin)-Min(Calcul_Datedebut) &lt; 30, 0, Max(Calcul_DateFin)-RangeMax(DateFinExo,Min(Calcul_Datedebut))+1)</LI-CODE> <P>&nbsp;</P> Tue, 28 Mar 2023 17:37:12 GMT https://community.qlik.com/t5/QlikView/DATEDIFF-function-in-qlik-sense/m-p/2054307#M1223101 MarcoWedel 2023-03-28T17:37:12Z