Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Master Calendar Flag

Looking for a master calendar flag that shows me last year through this month last year.

Ex:1

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
Highlighted

Re: Master Calendar Flag

May be like this:

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