Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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,