compare period

jrhuigsloot — Thu, 06 Sep 2018 06:55:31 GMT

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

topic compare period in App Development