topic Re: How to enable filtering in set analysis in QlikView

How to enable filtering in set analysis

JLL72 — Fri, 20 Nov 2020 18:58:42 GMT

I have this set analysis below to work out sum of sales for the past 12 months ( my MonthYear Numberic column is like 202009, 202008 )

=NUM(SUM(

{1<[MonthYear Numeric] = {"<=$(=Max([MonthYear Numeric])) >$(=Max([MonthYear Numeric])-100)"},
>}Sales),'€#,##0')

But this set anlysis is fixed at the moment, when I try to apply filters, this expression wouldn't be affected.

I need to filter this by [Client] and [Product]...

Could someone please help me?

Thanks

Joe

Anil_Babu_Samineni — Tue, 17 Nov 2020 19:52:27 GMT

Try this

=NUM(SUM({<[MonthYear Numeric] = {">=$(=AddMonths(Max([MonthYear Numeric]),-12))<=$(=Max([MonthYear Numeric]))"}>}Sales),'€#,##0')

JLL72 — Tue, 17 Nov 2020 22:34:37 GMT

Thank you ! worked perfectly !