https://community.qlik.com/t5/QlikView/Find-First-Date-and-last-date-in-month/m-p/2000609#M1221369 <P>Hello!</P> <P>Many thanks in advance for your response...&nbsp;</P> <P>I have created a field 'Dates' which is the load date for each of my files.</P> <P>I want to be able to extract the first load date and last load date from each month.</P> <P>I then want to be able to store the first and last load dates as a variable to use in a set expression for charts + other kpis.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Purple_13s_1-1667557614998.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92926i83E1F7B12EB71566/image-size/medium?v=v2&amp;px=400" role="button" title="Purple_13s_1-1667557614998.png" alt="Purple_13s_1-1667557614998.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 04 Nov 2022 13:58:13 GMT Purple_13s 2022-11-04T13:58:13Z https://community.qlik.com/t5/QlikView/Find-First-Date-and-last-date-in-month/m-p/2000609#M1221369 <P>Hello!</P> <P>Many thanks in advance for your response...&nbsp;</P> <P>I have created a field 'Dates' which is the load date for each of my files.</P> <P>I want to be able to extract the first load date and last load date from each month.</P> <P>I then want to be able to store the first and last load dates as a variable to use in a set expression for charts + other kpis.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Purple_13s_1-1667557614998.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/92926i83E1F7B12EB71566/image-size/medium?v=v2&amp;px=400" role="button" title="Purple_13s_1-1667557614998.png" alt="Purple_13s_1-1667557614998.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 04 Nov 2022 13:58:13 GMT https://community.qlik.com/t5/QlikView/Find-First-Date-and-last-date-in-month/m-p/2000609#M1221369 Purple_13s 2022-11-04T13:58:13Z https://community.qlik.com/t5/QlikView/Find-First-Date-and-last-date-in-month/m-p/2000655#M1221375 <P>Not sure exactly what you are trying to do but have you looked at the on-line help?</P> <P>There are examples of using the Group By in the load script...</P> <P><A href="https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/AggregationFunctions/max.htm" target="_blank">Max - script function ‒ Qlik Sense on Windows</A></P> <P><A href="https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/AggregationFunctions/min.htm" target="_blank">Min - script function ‒ Qlik Sense on Windows</A></P> <P>&nbsp;</P> Fri, 04 Nov 2022 11:56:23 GMT https://community.qlik.com/t5/QlikView/Find-First-Date-and-last-date-in-month/m-p/2000655#M1221375 AndyC 2022-11-04T11:56:23Z