Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Year Over Year Comparison ..

Hello Guys, I need Help with calculating Year over Year Sales But I also need the last year's date should be a working day.

For example

Aug 5th 2013 is Monday

Aug 5th 2012 is Sun

So if the same date falls on a weekend then i want the next weekday Aug 6th 2012 selected from the previous year .

1 Reply
MVP
MVP

Re: Year Over Year Comparison ..

Try like this:

Expression: =Sum({<Date={'$(=Date(Addmonths(Max(Date),-12)+vWeekend))'}>}Sales)

where,

vWeekend=Pick(Match(Num(Weekday(Addmonths(Max(Date),-12))),6,5) ,1,2)

PFA

Community Browser