How to calculate Average of 4 hours and cumulative

[New-Qlik]

Hi Everyone ,

I have to calculate average4 hour, average8 hour, Forecast - 12 Hours on Actual and cumulative .

I have two columns date and quantity.

Average of 4 hours will be : last four hour average , I need to display it wrt to time.

Please see attached excel for you reference.

Thanks In Advance.

Best Regards

Avneet

[Anonymous]

Hi

Will you post all Today's query in a separate link ...

My only intention is not to prolong this discussion thread.

[New-Qlik]

Sure.

I have created new one.Thanks

Kindly have a look.