Discussion board where members can get started with QlikView.
I need to load data that has a registration date from each October up to 5 years ago but i'm struggling to work out the where clause.
If i were to load data today (3rd September 2016) it would be from 1st October 2011
but next month being October 2016 it would load data from October 2012 onwards until...
...in October 2017 it would load data from October 2013 and so on from each October each year
Any ideas how best to accomplish this much appreciated
[CMS Created Date],
//date filtering would go here ideally based on [CMS Created Date] field
Try something like
[CMS Created Date] >= Yearstart(Today(1), -4,10);
View solution in original post
Perfect - Thank You