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