Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
((Sum(Sales)-(before(Sum(Sales))))/(Before(Sum(Sales))))*100
This Expression is used for above view..which shared image
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.
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