Same Weekday same Week Last Year as part of a range covering last 7 days with hourly sales data

New-Qlik — Tue, 17 Mar 2020 09:33:03 GMT

Hello,

I have calculated sales TY This week vs LY this week using below expression

Now i i want to compare todays sales at this time with ly sales at this time too, any leads?

Dimension:

DEC_Date

Expressions:

1) Only({<DEC_Date = {">=$(=MakeWeekDate(Year(today()), Week(today()-7), WeekDay(today()-7)))<=$(=MakeWeekDate(Year(today()), Week(today()-1), WeekDay(today()-1)))"}>}Value)

2) Below(Only({<DEC_Date = {">=$(=MakeWeekDate(Year(today())-1, Week(today()-7), WeekDay(today()-7)))<=$(=MakeWeekDate(Year(today())-1, Week(today()-1), WeekDay(today()-1)))"}>}Value), 7)

Re: Same Weekday same Week Last Year as part of a range covering last 7 days with hourly sales data

swarnendu — Tue, 17 Mar 2020 10:39:34 GMT

vLastYearDay: Date(AddYears(Today(), -1))

vLastFiscalYearStart : if(vLastYearDay < Date('7/1/'&(Year(Today())-1)),'7/1/' &(Year(Today())-2),'7/1/'&(Year(Today())-1))

Sum({$<MonthFieldName=, YearFieldName=, QuarterFieldName=, Date={">=$(=vLastFiscalYearStart)<$(=vLastYearDay)"}>} MeasureName)

topic Re: Same Weekday same Week Last Year as part of a range covering last 7 days with hourly sales data in App Development

Same Weekday same Week Last Year as part of a range covering last 7 days with hourly sales data

Re: Same Weekday same Week Last Year as part of a range covering last 7 days with hourly sales data