topic Aggregation by Year and month in set analysis in App Development

Aggregation by Year and month in set analysis

Peony — Wed, 26 Feb 2025 19:58:25 GMT

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

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?

Re: Aggregation by Year and month in set analysis

morgankejerhag — Thu, 27 Feb 2025 07:57:36 GMT

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

Re: Aggregation by Year and month in set analysis

Peony — Mon, 03 Mar 2025 21:23:51 GMT

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