https://community.qlik.com/t5/QlikView/Set-analysis-in-a-variable-time-window/m-p/1522817#M1291709 <P>Perhaps this?</P><P><STRONG>Sum({&lt;ACQ/VIN= {'ACQUISTO'}, DateField={"&gt;=$(=Date(Max(DateField-30),'DateFormat'))&lt;=$(=Date(Max(DateField),'DateFormat'))"}&gt;} Value)</STRONG></P> Thu, 20 Dec 2018 04:01:31 GMT Anil_Babu_Samineni 2018-12-20T04:01:31Z https://community.qlik.com/t5/QlikView/Set-analysis-in-a-variable-time-window/m-p/1522633#M1291707 <P>Hi, i need to calculate the sum of an import in a time window of 30 days, that user can choose clicking on the date.</P><P>So i have to click on one day and it should calculate the sum of these values in case the field is ACQ/VIN= 'ACQUISTO' in the previous 30 days.</P><P>How can i do it?</P><P>&nbsp;</P> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-a-variable-time-window/m-p/1522633#M1291707 matbelli 2026-01-26T18:19:17Z https://community.qlik.com/t5/QlikView/Set-analysis-in-a-variable-time-window/m-p/1522817#M1291709 <P>Perhaps this?</P><P><STRONG>Sum({&lt;ACQ/VIN= {'ACQUISTO'}, DateField={"&gt;=$(=Date(Max(DateField-30),'DateFormat'))&lt;=$(=Date(Max(DateField),'DateFormat'))"}&gt;} Value)</STRONG></P> Thu, 20 Dec 2018 04:01:31 GMT https://community.qlik.com/t5/QlikView/Set-analysis-in-a-variable-time-window/m-p/1522817#M1291709 Anil_Babu_Samineni 2018-12-20T04:01:31Z