Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nevilledhamsiri
Valued Contributor

Average over latest three Months

Hi Experts (Expect Dear Sunny to look in to this in particular)!

Kindly note that to arrive at profits, I have considered values over four Months of different variables. If I am to take in to account averages of latest three Months, what additional features to be brought in to all these average expressions except claims which is purely the Month scenario which could be taken as it is. I need this from October back wards. Also I prefer if this expression looks very simple & user friendly. If one may suggest any additional part to be linked to he current expression that would be fine.

Thanks in Advance

Neville

2 Replies
Highlighted
nevilledhamsiri
Valued Contributor

Re: Average over latest three Months

Dear Friends!

Please see in to this . I expect latest three Months average to be shown. The formula for average already stated is expected to be modified to incorporate  this.

Thanks & Regards

Neville 

nevilledhamsiri
Valued Contributor

Re: Average over latest three Months

Dear Sunny!

If possible please look in to this & let me have an easy solution on the requested output! Dearly looking forward an answer for this.

Regards

Neville