topic Re: Calculate YoY, MoM, Wow in one view in QlikView

Calculate YoY, MoM, Wow in one view

Praveen579 — Sat, 16 Nov 2024 20:00:38 GMT

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.

Re: Calculate YoY, MoM, Wow in one view

miskinmaz — Thu, 26 Sep 2019 09:33:50 GMT

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.

Re: Calculate YoY, MoM, Wow in one view

Praveen579 — Thu, 26 Sep 2019 11:31:45 GMT

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

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

Re: Calculate YoY, MoM, Wow in one view

miskinmaz — Fri, 27 Sep 2019 12:39:52 GMT

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.

Re: Calculate YoY, MoM, Wow in one view

Brett_Bleess — Mon, 07 Oct 2019 19:44:00 GMT

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