Rolling 12 month count not working with embedded set analysis

Anonymous — Mon, 31 Oct 2016 19:05:22 GMT

Hello,

I'm having an issue calculating a rolling 12 month count of records. It works for all of my line charts, however, when I add an embedded set analysis statement, the rolling 12 month set analysis no longer work. Would anyone have a solution?

The above expression works perfectly, however, when I add the embedded set analysis like the expression below, it no longer works.

count(DISTINCT{<Calendar.C_YEAR_DASH_MONTH={">=$(=Addmonths(MAX(DATE#(Calendar.C_YEAR_DASH_MONTH,'YYYY-MM')),-12))<=$(=MAX(DATE#(Calendar.C_YEAR_DASH_MONTH,'YYYY-MM')))"},Calendar.Date=, Calendar.MONTH=,Calendar.Year=,Fact.ACCOUNT = p({$<Fact.POI_VALUE = {1}>}Fact.ACCOUNT), Metric1.Description *= e(Metric1.Description) >} Fact.ACCOUNT))

Any help is greatly appreciated.

topic Rolling 12 month count not working with embedded set analysis in QlikView

Rolling 12 month count not working with embedded set analysis