Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rolling 12 month count not working with embedded set analysis

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?

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))


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.

0 Replies