Announcements
cancel
Showing results for
Did you mean:
Contributor

## Calculate YoY, MoM, Wow in one view

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.

Labels (3)

• ### YOY

4 Replies
Creator III

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.

Contributor
Author

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

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

Creator III

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.

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

Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Community Browser