Calculate YoY, MoM, Wow in one view

[Praveen579]

HI,

I want calculate  YoY, MoM, WoW in one view.

I have created one calculation , based on that I can able to show YoY  but when I drill-down the date by Month and Week that calculation is working at Year level but I want show the results by the drill down data (Year or Month or week) . In the attached image week is calculating with previous week but I need

1. Current week vs Previous month current week

2. Current Month vs Previous year current month

3. Current Year vs Previous Year

Would you pls help in this.

[miskinmaz]

Can you post the expression you have used.

If you have used aggr in the expression then you should specify the month and week also.

[Praveen579]

((Sum(Sales)-(before(Sum(Sales))))/(Before(Sum(Sales))))*100

This Expression is used for above view..which shared image

[miskinmaz]

It is better to use set analysis to calculate the MOM and YOY like:

sum(Sales)=sum({<Year={"=$(=max(Year)-1)"}>}Sales) and so on.

https://community.qlik.com/t5/QlikView-Documents/YTQ-QTD-MTD-and-WTD/ta-p/1489245.

Before and After function works on last sort of dimension column.

[Brett_Bleess]

If you are still looking for ideas, have a look at the following Design Blog post, not sure it can do all at once, will likely need Set Analysis in that case:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Here is a good Set Analysis Design Blog post as well:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett