Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Praveen579
New 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)
4 Replies
Highlighted
miskinmaz
Contributor III

Re: Calculate YoY, MoM, Wow in one view

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.

Highlighted
Praveen579
New Contributor

Re: Calculate YoY, MoM, Wow in one view

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

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

Highlighted
miskinmaz
Contributor III

Re: Calculate YoY, MoM, Wow in one view

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.

Highlighted
Digital Support
Digital Support

Re: Calculate YoY, MoM, Wow in one view

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.