topic Re: selections in filter should not affect table in QlikView

selections in filter should not affect table

vikasshana — Tue, 05 Aug 2025 11:37:45 GMT

Hi,

I've below 6 filters in my app

Year

Month

Quarter

Period

Business

Country

And I've below set analysis expression in a table to calculate 12 month rolling using the Period field.

sum({<Period={">=$(=Date(AddMonths(Max(Date#(Period, 'YYYYMM')), -11), 'YYYYMM')) <=$(=Max(Period))"}>}Sales).

So my requirement is if I make selection in Year, Month, Quarter, Period filters it should not effect the table. I tried below expression but it is not working.

sum({<Year=, Month=, Quarter=, Period=,Period={">=$(=Date(AddMonths(Max(Date#(Period, 'YYYYMM')), -11), 'YYYYMM')) <=$(=Max(Period))"}>}Sales)

Could you please help me on that.

Regards,

Re: selections in filter should not affect table

TheLazyDeveloper — Tue, 05 Aug 2025 13:41:18 GMT

I believe you would need to add the ignore field into the Max expressions as well or just apply outer set analysis so it filters down in the entire measure.

{<Year=, Month=, Quarter=, Period=>}

sum({<Period={">=$(=Date(AddMonths(Max(Date#(Period, 'YYYYMM')), -11), 'YYYYMM')) <=$(=Max(Period))"}>}Sales)

Re: selections in filter should not affect table

vikasshana — Tue, 05 Aug 2025 15:14:36 GMT

I tried with the expression which you recommended but it is still the same.

Re: selections in filter should not affect table

vikasshana — Tue, 05 Aug 2025 15:41:16 GMT

This expression is working, if we ignore fields inside max expressions.

sum({<Year=,Month=,Quarter=,Period=,Period={">=$(=Date(AddMonths(Max({<Year=,Month=,Quarter=,Period=,Period=>}Date#(Period, 'YYYYMM')), -11), 'YYYYMM')) <=$(=Max({<Year=,Month=,Quarter=,Period=,Period=>}Period))"}>}Sales)