compare period

[jrhuigsloot]

Hi,

can someone help me to make the following data in the MasterCalendar but then from last year in QlikSense?

if(TempDate >= date(today()-7) and TempDate < date(today()), 1, 0) as SevenDays,

if(InMonth (TempDate, date(today()), 0), 1, 0) as CurrentMonth,

if(InYearToDate (TempDate, date(today()), 0), 1, 0) as YTD,

if(TempDate >= MonthStart(today()) and TempDate < date(today()), 1, 0) as MTD,

Thx!

Jacqueline