topic Set Analysis For Period Comparisons in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-For-Period-Comparisons/m-p/975017#M1295957 <HTML><HEAD></HEAD><BODY><P>How to write a set analysis for showing data for Jan-Sep for the current year 2015 and Jan-Dec for all the previous years as I have data upto Sep'15 only for this year.</P><P></P><P>Thnks in advance</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT pkpandey 2026-01-26T18:19:17Z Set Analysis For Period Comparisons https://community.qlik.com/t5/QlikView/Set-Analysis-For-Period-Comparisons/m-p/975017#M1295957 <HTML><HEAD></HEAD><BODY><P>How to write a set analysis for showing data for Jan-Sep for the current year 2015 and Jan-Dec for all the previous years as I have data upto Sep'15 only for this year.</P><P></P><P>Thnks in advance</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-For-Period-Comparisons/m-p/975017#M1295957 pkpandey 2026-01-26T18:19:17Z Re: Set Analysis For Period Comparisons https://community.qlik.com/t5/QlikView/Set-Analysis-For-Period-Comparisons/m-p/975018#M1295960 <HTML><HEAD></HEAD><BODY><P>Add a calendar script to your data.&nbsp; Then using this add a YTD/ROY flag, selecting YTD will show you 2014 Jan - Sep, and 2015 Jan-Sep.&nbsp; Including ROY will then show 2014 Jan-Dec and 2015 Jan-Sep.</P><P></P><P>Adding a script like this using the transaction date automatically updates each month so the above is always available.</P></BODY></HTML> Wed, 11 Nov 2015 12:35:23 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-For-Period-Comparisons/m-p/975018#M1295960 dmac1971 2015-11-11T12:35:23Z