# Qlik Sense App Development

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Contributor

## Re: Last Year Same Day Sales

pls. find attach the data files (QVD) for the sample data as well.

Partner

## Re: Last Year Same Day Sales

PFA..

Worked with LastYTDflag.

Contributor

## Re: Last Year Same Day Sales

I need Sales for Last Year Same day that is 01-Dec-2016 is thursday, so I need sales on thursday last december which is 03-Dec-2015.

The below is the formula;

Sum(

{<

[Date]={\$=(Max([Date])-364)}

>}

Sales

)

but as explained its not working. I dont need last year same date sales.

Partner

## Re: Last Year Same Day Sales

Calculate WeekDay , Week , Year in master calendar by using

weekday(Date) as WeekDay,

week(Date) as Week,

Year(Date) as Year

expression as

sum( { < WeekDay = {"\$(= weekday( max(Date)))"} , Week = {"\$(=week(max(Date)))"}, Year = {"\$(=year(Max(Date))-1)"} > } Sales )

Contributor

## Re: Last Year Same Day Sales

I dont need last year same date sales but if this is also working then my job is over.

Select Nov-2016 and see whether the results are appearing?

Partner

## Re: Last Year Same Day Sales

sum( { < WeekDay = {"\$(= weekday( max(Date)))"} , Week = {"\$(=week(max(Date)))"}, Year = {"\$(=year(Max(Date))-1)"} > } Sales )

this expression will consider weekday as Mon,Tue, etc to compare with last year

Contributor

## Re: Last Year Same Day Sales

Formula seems to be correct but its not working. U have the test application; can u try on that?

Partner

## Re: Last Year Same Day Sales

can you send the one you tried with this expression?

Contributor

## Re: Last Year Same Day Sales

its the same i uploaded here before

Contributor

## Re: Last Year Same Day Sales

pls. find attached the app i tried with,