Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jeckstein
Partner - Creator
Partner - Creator

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
sunny_talwar

May be like this:

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