Exclude current month for an average

[QlikSensor]

Hi, I need to get the average values of Fiscal Years. For a full fiscal year (e. g. 2018 which is from Oct 2017 to Sep 2018) this is no problem. But for the current fiscal year we have a definition to exclude the current month.

Let's say, we are currently in September of FY2019. I would need to get the average of all values for 2019 except the current month. This means: Data from Oct 2018 to Aug 2019 which has to be divided through 11.

Any hints how to do that? I have no clue. Thanks for helping.

[martinpohl]

Hi,

you can achieve this by creating a complex expression in your chart.

Or keep it simple, creat a flag in your script with

1 for all completed months

0 for actual (not completet) month

and calculate your average with

{<Complete = {1}>}

Regards