Discussion board where members can get started with QlikView.
Looking for a master calendar flag that shows me last year through this month last year.
Today is Oct 18, 2016
I need a flag that will grab all dates from
Jan 1, 2015 - Oct 31, 2015.
Today is Jan 17,2016
Flag should mark all dates
Jan 1,2015 - Jan 31,2015
May be like this:
If(TempDate >= YearStart(Today(1), -1) and TempDate <= MonthEnd(Today(1), -12), 1, 0) as Flag