Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

Aggregation by Year and month in set analysis

Hi everyone. I have a data set like the one below (excel version is attached as well):

Peony_0-1740599852413.png

 


To receive values for Total Sales and Total Sales YoY measures I use expressions below:
Total Sales:           Sum({<Fiscal_Week_End=, Last_12_Fiscal_Months_Flag={"1"}>} Sales)
Total Sales YoY:    Sum({<Fiscal_Week_End=, Last_12_Fiscal_Months_YoY_Flag={"1"}>} Sales)

As final result I need place "Total Sales YoY" on the same rows with "Total Sales". And I understand that I need to add some aggregation to "Total Sales YoY" to get result. But none of the options I tries does not bring me expected result. Maybe someone has any advice what to do with this case? 

Labels (3)
1 Solution

Accepted Solutions
morgankejerhag
Partner - Creator III
Partner - Creator III

So for 2025 feb you want to get the values for 2024 feb as well to do YoY calculation? I would solve this with an As of Calendar. An as of calendar allows you to reach other periods in the data that the current dimension value is slicing.
https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130

View solution in original post

2 Replies
morgankejerhag
Partner - Creator III
Partner - Creator III

So for 2025 feb you want to get the values for 2024 feb as well to do YoY calculation? I would solve this with an As of Calendar. An as of calendar allows you to reach other periods in the data that the current dimension value is slicing.
https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130

Peony
Creator III
Creator III
Author

@morgankejerhag thank you. This solution is precisely what I needed!