Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

madnanansari
Contributor

Re: Last Year Same Day Sales

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

Partner
Partner

Re: Last Year Same Day Sales

PFA..

Worked with LastYTDflag.

madnanansari
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
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 )

madnanansari
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
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

madnanansari
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
Partner

Re: Last Year Same Day Sales

can you send the one you tried with this expression?

madnanansari
Contributor

Re: Last Year Same Day Sales

its the same i uploaded here before

madnanansari
Contributor

Re: Last Year Same Day Sales

pls. find attached the app i tried with,