Auto Calendar: MonthsAgo stopped working correctly

katierusso — Fri, 25 Aug 2023 19:47:56 GMT

This was working the last time I had the app open. Now it seems like Qlik is ignoring the set expression.

Qlik Sense February 2023 Patch 7

Using this formula in a KPI: sum({<[my_date.autoCalendar.MonthsAgo]={0}>} my_count)

Using Auto Calendar code:

[autoCalendar]:
DECLARE FIELD DEFINITION Tagged ('$date')
FIELDS
12*Year(vMaxMonth)+Month(vMaxMonth)-12*Year($1)-Month($1) AS [MonthsAgo] ,
floor((12*Year(vMaxMonth)+Month(vMaxMonth)-12*Year($1)-Month($1))/12) AS [Rolling12Mo] ,
Month(vMaxMonth)-Month($1) AS [MonthRelNo] ,
If(WeekDay($1)<=WeekDay(vMaxMonth),1,0) AS [InWTD] ,
(WeekStart(vMaxMonth)-WeekStart($1))/7 AS [WeeksAgo] ,
Week(vMaxMonth)-Week($1) AS [WeekRelNo] ;

DERIVE FIELDS FROM FIELDS [my_date] USING [autoCalendar] ;

Re: Auto Calendar: MonthsAgo stopped working correctly

katierusso — Fri, 25 Aug 2023 19:58:00 GMT

Notice that the MonthsAgo field is populating correctly in this table too! Why is this no longer working in set expressions?

topic Auto Calendar: MonthsAgo stopped working correctly in App Development

Auto Calendar: MonthsAgo stopped working correctly

Re: Auto Calendar: MonthsAgo stopped working correctly