topic Re: Last 6 month Average on day level data in QlikView

Last 6 month Average on day level data

Wed, 07 Sep 2016 06:33:37 GMT

Hi All,

I have a day level data and need to show the last 6 month average in a table.

I have the data as follows,

Need the output in the following format,

Calculation logic --> (sum of last 6 months sales)/6 (exclude current month data)

Some one who can show how this can be implemented in table chart will be lot of help.

Thanks in advance. I have attached the data in excel sheet for your convenience.

Anil_Babu_Samineni — Wed, 07 Sep 2016 15:41:07 GMT

Perhaps this

Sum({<Month = {"=$(=AddMonths(max(Month(Datefield))),-6)"}>} Sales) / Count ({<Month = {"=$(=AddMonths(max(Month(Datefield))),-6)"}>} Sales)

sunny_talwar — Wed, 07 Sep 2016 17:49:46 GMT

Do you have gaps in your dates or is this how your data is laid out? May be use The As-Of Table