Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Reply
sunny_talwar
MVP
MVP

May be like this:

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