topic Re: Rolling Twelve Months in App Development

Rolling Twelve Months

arvindjha2050 — Tue, 21 Dec 2021 20:43:45 GMT

Hello Team,

I have requirement for Rolling Period in Line Chart

Dimension : Year

Measure : sum(Attrition) for the year / average(employees) for last 12 months

The problem is the dimension Year where we need to calculate average for rolling last 12 months .

For example for Dimension 2019 : Number of employees who left in 2019 / Average of employees for last 12 months(i.e. from Mar 2018 to Feb 2019)

How can it be done?

Thanks

Re: Rolling Twelve Months

pradosh_thakur — Sat, 16 Feb 2019 07:24:25 GMT

if you have a date column it will be easier to do so

Please refer the below for reference.

https://community.qlik.com/t5/QlikView-Documents/Date-Level-Analysis-WTD-MTD-QTD-YTD-Current-Year-Previous-Year/ta-p/1495515

What do you mean by average of employees here?

Re: Rolling Twelve Months

pradosh_thakur — Sat, 16 Feb 2019 07:27:33 GMT

something similar to below should work Please check the field names once
dimension = year

measure = sum(Attrition)/ (count(Distinct{<date_column={">=addmonths(today(),-12)  <= today()"}>} Empoyees)/12)

Re: Rolling Twelve Months

arvindjha2050 — Sat, 16 Feb 2019 11:55:38 GMT

Hello Pradosh,

This does not work.

I have a date field also , my dimension is Year(DateField).

The problem is for instance when this field has value 2019 it is not able to fetch values of Year 2018 but we want sum of rolling twelve months which in many cases will require data from past year also.

Regards,

Arvind