Average Closing Stock

[Anonymous]

Hi Team,

I have a formula which will gives me closing stock till max date.

For example i need to calculate Average closing stock  for 100 days. My formula will gives me the stock on 100th days. Is there any way to calculate Day1 closing stock+day2 Closing stock+day 3 closing stock.....till 100th day.

Thanks in advance.

Regards,

Sadasiva

[mbrdenmark]

Hi Sada

Depending on your datastructure, you should take a look into the RangeAvg function in combination with Above().

RangeAvg ‒ QlikView

See the "example with expression" part in the above link.

So if you have a daily dimension, you should be able to use the following.

RangeAvg (Above(MyField,0,100))