Discussion Board for collaboration related to QlikView Deployment.
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.
Thnks in advance
Add a calendar script to your data. Then using this add a YTD/ROY flag, selecting YTD will show you 2014 Jan - Sep, and 2015 Jan-Sep. Including ROY will then show 2014 Jan-Dec and 2015 Jan-Sep.
Adding a script like this using the transaction date automatically updates each month so the above is always available.