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

[New-Qlik]

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)

[swarnendu]

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)