topic Re: Set Analysis to ignore filter in App Development

Set Analysis to ignore filter

JuMo — Tue, 03 Jun 2025 08:53:25 GMT

In one chart, i am using a set analysis to ignore the selection on the month filter

Sum({<[Calendar.Month]=>} Fact.Actual)

And it works correctly, it making the sum for all the month ignoring the month selected

However, when I introduce another factor to the set analysis, the sum is calculated only for the selected month

Sum({<[Calendar.Month]=>*<Product = {"Product 1"}>} Fact.Actual)

Shall I use another operator ?

seanbruton — Tue, 03 Jun 2025 09:12:14 GMT

Hi JuMo,

Please try this and see if it works for you.

Sum({<[Calendar.Month]=-,Product = {"Product 1"}>} Fact.Actual)

Sum({<[Calendar.Month]=,Product = {"Product 1"}>} Fact.Actual)

Regards

Sean

JuMo — Tue, 03 Jun 2025 09:15:03 GMT

Thanks you Sean, its not working

However I've tried with an outer set expression and it works ...

{<[Calendar.Month]=>} Sum({<Product = {"Product 1"}>} Fact.Actual)

... I don't know why