Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY

Master Calendar Flag

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.

Ex 2:

Today is Jan 17,2016

Flag should mark all dates

Jan 1,2015 - Jan 31,2015

1 Reply

Re: Master Calendar Flag

May be like this:

If(TempDate >= YearStart(Today(1), -1) and TempDate <= MonthEnd(Today(1), -12), 1, 0) as Flag